Обсуждение: Fw: Problem regarding PostgreSQL
Can someone comment on this? Dear Tatsuo Ishii, We have been trying to install PostgreSQL 6.5.3, that had come with Redhat 6.2. The installation of postgres 6.5.3 was completed.The "initdb" comand executed succesfully. but during the "createdb" command it gives me error that"connection todatabase 'template1' failed. connectDB() --connect() failed: connection refused. Is the postmaster running at 'localhost' and accepting connections on unix socket 5432? createdb:database creation failedon postgres." Please help for this situation at smps@enfinet.net or kalpan_vyas@yahoo.com. Thanks Kalpan
I'm not sure the standard Red Hat install (or Postgres rpm) starts the server with the -i option. He didn't mention whether they were on the same machine or not. Len Morgan
----- Original Message ----- From: Tatsuo Ishii <t-ishii@sra.co.jp> To: <pgsql-general@postgresql.org> Sent: Wednesday, August 23, 2000 9:04 AM Subject: [GENERAL] Fw: Problem regarding PostgreSQL > Can someone comment on this? > Please check if your postmaster is actually running..;-) Perhaps the command: ps -aux | grep postgres Would shed some light on the matter... If there is no postgres daemon running... Then please start one up.. Under redhat this should be done by executing the following: /etc/rc.d/init.d/postgresql start Hope that helps... Cheers, John Clark
Len Morgan wrote: > I'm not sure the standard Red Hat install (or Postgres rpm) starts the > server with the -i option. He didn't mention whether they were on the same > machine or not. > > Len Morgan The standard Red Hat install include the -i option but it doesn't start at all the first time. Here is the default command line into the init script : su -l postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql' So you first have to run : /etc/rc.d/init.d/postgresql start It will run initdb, create the database architecture into /var/lib/pgsql/ and create the famous base template1... After that you can run psql template1 without problems. Here is what RH done : [root@gdarold /root]# /etc/rc.d/init.d/postgresql start Checking postgresql installation: no database files found. We are initializing the database system with username postgres (uid=26). This user will own all the files and must also own the server process. Creating Postgres database system directory /var/lib/pgsql/base Creating template database in /var/lib/pgsql/base/template1 Creating global classes in /var/lib/pgsql/base Adding template1 database to pg_database... Vacuuming template1 Creating public pg_user view Creating view pg_rules Creating view pg_views Creating view pg_tables Creating view pg_indexes Loading pg_description Starting postgresql service: postmaster [1078] [root@gdarold /root]# su - postgres bash$ psql template1 Then all works fine Hope this help ! Regards,