newbe question

login as the root and at the linux prompt # type following
=======example=======
ps aux | grep postmaster
=====================

then You should get few lines containig one looking like that, notice the text "postmaster" at the end of line:
=====example===========
postgres 345 0.0 2.9 3376 904 ? S 12:31 0:00 /usr/bin/postmaster -
=======================
if not, then the backend server is not running - so it is not installed

-----Original Message-----
From: Phil Oelkers [SMTP:Phil.Oelkers@experian.com]
Sent: Tuesday, August 24, 1999 6:00 PM
To: Pgsql-general@postgreSQL.org
Subject: [GENERAL] newbe question

Ok I'm and old pro at SQL (DB2, Access) but a total Linux/Unix idiot.

I have Mandrake RedHat Linux and think I have postgresql installed.

At the shell I type

psql template1

Linux complains

connectDB() failed: Is postmaster running and accepting conections at
'UNIX SOCKET' on port 5432

Being a near complete Linux idiot I have no clue what this means.

Anybody care to help?

Thanks

Phil Oelkers
Database Analyst - Team O
Experian DirectTech

************

If you see that postmaster is indeed running, then most likely it was not
started with the -i switch. This switch is needed for tcp connections,
ie: port 5432. This is covered in the Client Connection Problems section
of the documentation.

HTH
Rick
=============================================================
On Tue, 24 Aug 1999, [iso-8859-2] Daniel P���der wrote:

If postmaster is really running, su the user who running postmaster
(should not be root).
and run the following two commands.

$ initdb
$ createuser anyuser

According to your Linux distribution, initdb may have been performed.
(my RedHat 6.0 scripts for postgres in rc.d/ directory runs initdb.)
In this case you don't have to run initdb.

On Tue, 24 Aug 1999, Daniel Pider wrote:

login as the root and at the linux prompt # type following
=======example=======
ps aux | grep postmaster
=====================

then You should get few lines containig one looking like that, notice the text "postmaster" at the end of line:
=====example===========
postgres 345 0.0 2.9 3376 904 ? S 12:31 0:00 /usr/bin/postmaster -
=======================
if not, then the backend server is not running - so it is not installed

-----Original Message-----
From: Phil Oelkers [SMTP:Phil.Oelkers@experian.com]
Sent: Tuesday, August 24, 1999 6:00 PM
To: Pgsql-general@postgreSQL.org
Subject: [GENERAL] newbe question

Ok I'm and old pro at SQL (DB2, Access) but a total Linux/Unix idiot.

I have Mandrake RedHat Linux and think I have postgresql installed.

At the shell I type

psql template1

Linux complains

connectDB() failed: Is postmaster running and accepting conections at
'UNIX SOCKET' on port 5432

Being a near complete Linux idiot I have no clue what this means.

Anybody care to help?

Thanks

Phil Oelkers
Database Analyst - Team O
Experian DirectTech

************

************

===============================================================================
Science is the game we play with God to find out what his rules are.
-------------------------------------------------------------------------------
Doo Suk Yang
Research Scientist Voice: 82-42-866-2222
LG Chemical Ltd. Research Park
Biotech Research Institute I FAX: 82-42-861-2566
-------------------------------------------------------------------------------
A fool hath no delight in understanding, but that his heart may discover itself.
(Proverbs 18:2)
===============================================================================