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

From Eric M. Wulff
Subject Re: postgres installed via rpms -can't run postmaster or postgres
Date
Msg-id 1066498319.2244.47.camel@ewulff
Whole thread Raw
In response to postgres installed via rpms -can't run postmaster or postgres  ("Eric M. Wulff" <ewulff@footbag.org>)
Responses Re: postgres installed via rpms -can't run postmaster or postgres
List pgsql-admin
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?

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



pgsql-admin by date:

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