From: | "dayat" <sql(dot)muda(at)yahoo(dot)co(dot)id> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to check whether PostgreSQL server is up and running? |
Date: | 2009-05-08 16:42:46 |
Message-ID: | 9A005490EE4A4DE7A06DF79CCBF0ABBE@dayatPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ok let's to create a cluster for you, be sure the pg8 directory owned by
postgres user and the directory is empty.
[postgres(at)callisto]$ initdb -D /usr/local/pgsql/postgresql-8.3.7/pg8 -U
postgres -W
Type your password if they ask, wait initdb process until finish.
And try the server:
[postgres(at)callisto]$ pg_ctl -D /usr/local/pgsql/postgresql-8.3.7/pg8 start
enter to database postgres with user postgres and type your password
[postgres(at)callisto]$ psql postgres postgres -W
Tell me if this not work.
Regards
Hidayat
----- Original Message -----
From: Jan Muhammad
To: pgsql-admin(at)postgresql(dot)org
Sent: Friday, May 08, 2009 4:11 PM
Subject: [ADMIN] How to check whether PostgreSQL server is up and running?
Hi,
After having various error message in starting PostgreSQL version
8.2.11; finally uninstalled/deleted it. Now trying my luck on 8.3.7, but
things haven't changed for me.
When I try to check that postmaster server is running or not? I get
the following error:
$ postmaster -D /usr/local/pgsql/data
LOG: could not translate host name "localhost", service "5432" to
address: Name or service not known
WARNING: could not create listen socket for "localhost"
FATAL: could not create any TCP/IP sockets
.......................................................................
Similarly when I try to start postgres server with
[postgres(at)callisto postgresql-8.3.7]$ pg_ctl -D pg8 start
postgres cannot access the server configuration file
"/usr/local/pgsql/postgresql-8.3.7/pg8/postgresql.conf": No such file or
directory
server starting
Have no idea what's wrong and where the problem is? Do I need to
change/edit some of Environment variable settings or what? Or should I
reinstall PostgreSQL with Yum?? Or should give up using PostgreSQL and
switch to some other DB like MySQL etc... No idea what to do.....?
Thanks in advance for help.
-Jan Muhammad
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Muhammad | 2009-05-08 17:28:31 | Re: How to check whether PostgreSQL server is up and running? |
Previous Message | Joshua D. Drake | 2009-05-08 14:42:23 | Re: How to run PostgreSQL? |