Postgres Pro
Downloads
Home   >   mailing lists

Thread: ...

...

From
Guido
Date:
I can't run postmaster.

The terms of the problems are:

Distro - RH 7.1
PGSQL - 7.1.3
I've setup the rc.d script with <chkconfig -add> so to have Postgresql
start at system boot and it works fine!
Now, in order to connect to the DB with a Java application, I need to
configure the Postgres server in order to accept TCP/IP connection. The
Programmer's Guide says to supply the -i flag when starting the postmaster,
but, I think, I'm already running the postmaster.
My question is :
    How can I enable the TCP/IP connection with the database already
running?

I've tried with the postmaster -i but I receive the following message:
    Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
    Is another postmaster (pid 801) running in "/var/lib/pgsql/data"?

Re:

From
Francisco Reyes
Date:
On Thu, 8 Nov 2001, Guido wrote:

>     How can I enable the TCP/IP connection with the database already
> running?

You need to bring it down and back up.
You may also want to look at the pg_hba.conf file. There you can specify
what hosts you want to allow connection to a TCP/IP port.
For example you can add entries like:
local        all                                           trust
host         all         127.0.0.1     255.255.255.255     trust
host         all         ###.#.###.##  255.255.255.255     trust

Where ## is replaced by the IP address of the machine you want to allow.

Re:

From
Isaac Sparrow
Date:
Guido,

If postmaster is not running with the "-i" flag try this.

cd /var/lib/pgsql/data

If the file postmaster.opts.default is not there, create it.

Add one line to the file:
-i

Now you need to save the file and restart postmaster.

Hope this helps.
--

-------------------------------------------------------------------
Isaac Sparrow
Staff Engineer
VisiComp, Inc.
http://www.visicomp.com

GnuPG Key Fingerprint:
1060 5A07 F6EC B2B3 9AAA 3EA5 7B79 EFE1 6397 4F47
Get my public key at:
http://www.concentric.net/~issparow

The devil finds work for idle circuits to do.


On Thursday 08 November 2001 10:36 am, Guido wrote:
> I can't run postmaster.
>
> The terms of the problems are:
>
> Distro - RH 7.1
> PGSQL - 7.1.3
> I've setup the rc.d script with <chkconfig -add> so to have Postgresql
> start at system boot and it works fine!
> Now, in order to connect to the DB with a Java application, I need to
> configure the Postgres server in order to accept TCP/IP connection. The
> Programmer's Guide says to supply the -i flag when starting the postmaster,
> but, I think, I'm already running the postmaster.
> My question is :
>     How can I enable the TCP/IP connection with the database already
> running?
>
> I've tried with the postmaster -i but I receive the following message:
>     Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
>     Is another postmaster (pid 801) running in "/var/lib/pgsql/data"?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


--

-------------------------------------------------------------------
Isaac Sparrow
Staff Engineer
VisiComp, Inc.
http://www.visicomp.com

GnuPG Key Fingerprint:
1060 5A07 F6EC B2B3 9AAA 3EA5 7B79 EFE1 6397 4F47
Get my public key at:
http://www.concentric.net/~issparow

The devil finds work for idle circuits to do.

Re:

From
"Brett W. McCoy"
Date:
On Thu, 8 Nov 2001, Guido wrote:

> I can't run postmaster.
>
> The terms of the problems are:
>
> Distro - RH 7.1
> PGSQL - 7.1.3
> I've setup the rc.d script with <chkconfig -add> so to have Postgresql
> start at system boot and it works fine!
> Now, in order to connect to the DB with a Java application, I need to
> configure the Postgres server in order to accept TCP/IP connection. The
> Programmer's Guide says to supply the -i flag when starting the postmaster,
> but, I think, I'm already running the postmaster.
> My question is :
>     How can I enable the TCP/IP connection with the database already
> running?
>
> I've tried with the postmaster -i but I receive the following message:
>     Lock file "/var/lib/pgsql/data/postmaster.pid" already exists.
>     Is another postmaster (pid 801) running in "/var/lib/pgsql/data"?

You need to shut the postmaster down ('kill 801' will do it), then start
it back up with the -i parameter.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Another megabytes the dust.