From: | Isaac Sparrow <isaac(dot)sparrow(at)visicomp(dot)com> |
---|---|
To: | Guido <lampo(dot)14(at)iol(dot)it>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2001-11-09 17:57:19 |
Message-ID: | 200111091757.JAA11772@www6.cruzio.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2001-11-09 18:12:15 | Using output of pg_ctl for benchmarking? |
Previous Message | Jason Earl | 2001-11-09 17:32:43 | Re: var size too small? |