[SMS]

[baboo]

I installed postgres from extras and postgres webmin module. No error installing.

In webmin clicking on postgres I get this error msg:
The PostgreSQL host configuration file /var/lib/pgsql/data/pg_hba.conf was not found on your system. Maybe PostgreSQL has not been initialised, or your module configuration is incorrect.

I tried to fillout module config but it will not save.

The file pg_hba.conf does not exist.

?

thanks

[gerasimos_h]

You need to initialize the Postgresql database before you run postgresql.

[baboo]

thanks for reply

the first command to initialize db works. However when trying to start using rc. command I get an error that says root is not allowed to start db. Same thing when trying from webmin.

sh: /etc/rc.d/rc.postgresql: Permission denied

when initializing here is the message at the end:
Success. You can now start the database server using:

postgres -D /var/lib/pgsql/data
or
pg_ctl -D /var/lib/pgsql/data -l logfile start

so do I need to create a user or is this a mistake in config of postgres?

[gerasimos_h]

You should have postgres user and group, this is from install script

[baboo]

aaah - found problem. rc.postgresql was not executable. changed and now works.

thanks for the help. Made you earn your money today