Re: postgres installed via rpms -can't run postmaster or postgres - Mailing list pgsql-admin

From Bruno LEVEQUE
Subject Re: postgres installed via rpms -can't run postmaster or postgres
Date
Msg-id 3F91975C.70300@net6d.com
Whole thread Raw
In response to Re: postgres installed via rpms -can't run postmaster or postgres  ("Eric M. Wulff" <ewulff@footbag.org>)
List pgsql-admin

Eric M. Wulff wrote:
> Great!  I very much appreciate your help.  I'm unclear on what I need to
> set PGDATA or the -D option with in order to run postmaster.  Any idea?

The line you need with postmaster should be like :

postmaster -i -D /PATH/WHERE/FIND/DATA/FILES -S

The /PATH/WHERE/FIND/DATA/FILES must be /var/lib/pgsql/data/ (or
/var/lib/pgsql)

The -i is for allowing clients to connect via TCP/IP
The -S is fot separating postmaster of the console launching it.

Bruno

>
> Here is what I'm trying and the errors given...
>
> $ postmaster
>
> "postmaster does not know where to find the database system data.
> You must specify the directory that contains the database system
> either by specifying the -D invocation option or by setting the
> PGDATA environment variable."
>
> So I tried
>
> $ postmaster -D /etc/rc.d/init.d"
>
> "FATAL:  data directory /etc/rc.d/init.d has group or world access;
> permissions should be u=rwx (0700)"
>
> So I changed the permissions but that didn't work either.
>
> again, many thx
> Eric
>
>
>
>
> On Sat, 2003-10-18 at 06:21, Bruno LEVEQUE wrote:
>
>>With  the postgresql-server-7.3-2PGDG.i386.rpm, you have installed a
>>file etc/rc.d/init.d/postgresql,
>>if you run it like postgresql start, you must start postmaster and so
>>you can connect.
>>(I am not a specialist of RH so may be there is other thinks to know)
>>
>>Bruno
>>
>>
>>Eric M. Wulff wrote:
>>
>>
>>>Hi, I am relatively new to Linux and just installed postgres via rpms.
>>>I think.  However, I can't for the life of me figure out how to start up
>>>postmaster or psql.
>>>
>>>psql - I keep getting the following error when running psql...
>>>
>>>"psql: could not connect to server: No such file or directory
>>>       Is the server running locally and accepting
>>>       connections on Unix domain socket "/tmp/.s.PGSQL.1234"?"
>>>
>>>How do I find out if the server is running locally and accepting
>>>connections on Unix domain socket?
>>>
>>>postmaster - I keep getting the following error when trying to start
>>>postmaster...
>>>
>>>"postmaster does not know where to find the database system data.
>>>You must specify the directory that contains the database system
>>>either by specifying the -D invocation option or by setting the
>>>PGDATA environment variable."
>>>
>>>Okay, set it to what?  man and postgres docs are of little help.  Any
>>>help is much appreciated.  Following are the rpm's I ran
>>>redhat-install-packages on.  I got them from a mirror off
>>>postgresQl.org...
>>>
>>>ostgresql-7.3-2PGDG.i386.rpm
>>>postgresql-python-7.3-2PGDG.i386.rpm
>>>postgresql-contrib-7.3-2PGDG.i386.rpm
>>>postgresql-server-7.3-2PGDG.i386.rpm
>>>postgresql-devel-7.3-2PGDG.i386.rpm
>>>postgresql-docs-7.3-2PGDG.i386.rpm
>>>postgresql-jdbc-7.3-2PGDG.i386.rpm
>>>postgresql-libs-7.3-2PGDG.i386.rpm
>>>postgresql-pl-7.3-2PGDG.i386.rpm
>>>
>>>Oh, and another thing I'm confused about is...  I tried to install these
>>>in /usr/local/bin, that's where the rpms are, but they wound up in
>>>/usr/lib.  Any idea why that might be?  I rpm'd from /usr/local/bin
>>>
>>>many thx
>>>Eric
>>>
>>>
>>>
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 8: explain analyze is your friend
>>>
>>>
>>>
>>
>>--
>>Bruno LEVEQUE
>>System Engineer
>>SARL NET6D
>>bruno.leveque@net6d.com
>>http://www.net6d.com
>>
>>
>
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com


pgsql-admin by date:

Previous
From: "Eric M. Wulff"
Date:
Subject: Re: postgres installed via rpms -can't run postmaster or postgres
Next
From: "Eric M. Wulff"
Date:
Subject: Re: postgres installed via rpms -can't run postmaster or