Installing the Arch server

[dedanna1029]

Code: Select all

ls -R /etc | grep postgresql

That should help you find out.

Edit: Whoops, sorry, upon looking...

https://wiki.archlinux.org/index.php/Po ... rom_remote

The PostgreSQL database server configuration file is postgresql.conf. This file is located in the data directory of the server, typically /var/lib/postgres/data. This folder also houses the other main config files, including the pg_hba.conf.

[viking60]

Yeah well I cannot find it there. And the password in posresq does not work either

[fukawi2]

EDIT: Whoops, didn't see the next page of replies... Give me 5 mins...

EDIT 2: The post-install script initializes a data directory in "/srv/pgData-8.4" so you should find postgresql.conf in there

[viking60]

Thank you Now I am confused at a higher level. can I use 10.0.0. in pg_hba.conf for allowing all the clients in my network?
And I sure need phppgadmin to work. I have created a database and get automatically in to postgres but when a password is needed, the generated one does not work.
Might be me - I am reading up on it now......
Where is config.inc.php for phppgadmin?

[fukawi2]

Make sure you're logging in as the 'postgres' user -- psql by default uses your Linux username.

IIRC, pg_hba.conf requires proper CIDR notation, so you need to use 10.0.0.0/24 instead of 10.0.0.

[viking60]

Thanks!
Well I have gotten this far:

Code: Select all

[thomas@rulle ~]$ psql thomasbase
psql (8.4.5)
Type "help" for help.

thomasbase=# \dt
No relations found.
thomasbase=# \du
            List of roles
 Role name | Attributes  | Member of
-----------+-------------+-----------
 postgres  | Superuser   | {}
           : Create role   
           : Create DB     
 thomas    | Superuser   | {}
           : Create role   
           : Create DB     

thomasbase=#

Now I kind of need to populate my databases (convert from mysql) -phppgadmin - next I guess

[fukawi2]

I've had good success with this script when doing MySQL to PG conversions:
http://pgfoundry.org/projects/mysql2pgsql/

[viking60]

Ok I'll give it a try even if tutorials are scarce there.
Oh boy I managede to convert it but getting it into the database is to much right now - going for Whiskey

[viking60]

I fond the Whiskey way more appealing than PG but the server has been up for 92 days and 2.47.41 h now. That counts for a server.

[fukawi2]

I fond the Whiskey way more appealing than PG but the server has been up for 92 days and 2.47.41 h now. That counts for a server.

That's awesome to hear
Have you been applying updates?
Which RC was the original installation? RC1 or RC2?
Any problems at all you came across that we should fix?

[viking60]

I think I started with RC1. And yes I have been updating all the way. I cannot see any pressing problem but some control panel stuff is lacking in the repos i think.
Everybody says webmin and cpanel when that comes up ( and so did I - in lack of better ideas). Something along those lines would be very "server" like.

[viking60]

Happy birthday Fukawi!