Postgres Pro
Downloads
Home   >   mailing lists

Thread: RE: [GENERAL] newbe question

RE: [GENERAL] newbe question

From
Daniel Péder
Date:
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



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

RE: [GENERAL] newbe question

From
Rick Henry
Date:
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:

>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
>
>
>
>************
>
>
>************
>

RE: [GENERAL] newbe question

From
microbe@chollian.net
Date:
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)
===============================================================================