On Saturday 07 December 2002 08:24 am, Jean Fleurant wrote: > Thanks. > I've started the service and did not receive any error message. > > Now I'd like to have acceess to a datatbase. I think that I need to > start the postmaster. > > I've run command "postmaster -D /var/lib/pgsql/data/" but I get > following error message: > FATAL 1: could not read permissions of directory /var/lib/pgsql/data/
If you already started the service, then assuming the database is running in the background, you don't need to run the postmaster command. To connect to the database (via console), simply run $ pgsql Basically, if you installed postgres using redhat rpm, others has explained to you how to start the service using redhat's script. If you install postgres from scratch (ie. compile your own), then you need to start the service using that "postmaster -D /database/path" command, as the database user, which can be anything. For example, if you create this user as postgress (root$ adduser postgress), then do su - postgress, and run that command (ie. postmaster). postgres is required to have read and write access to the /database/path/, which can be anywhere. In my case, I choose the /database/path to be /home/postgres/data, and postgress is able to read and write to /home/postgres/data. So I started my database service as postgres$ postmaster -D /home/postgres/data And as others have also pointed out, if you need to connect using php, run with the option -i to enable ip connection, eg: postgress$ postmaster -Di /home/postgres/data Hope that helps. Reuben D. Budiardja -- ------------------------------------------------- /"\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ ------------------------------------------------- Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. ------------------------------------------------- -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list