Thread: postgres installed via rpms -can't run postmaster or postgres

postgres installed via rpms -can't run postmaster or postgres

From
"Eric M. Wulff"
Date:
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





Re: postgres installed via rpms -can't run postmaster or postgres

From
"Eric M. Wulff"
Date:
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
>
>



Re: postgres installed via rpms -can't run postmaster or postgres

From
Bruno LEVEQUE
Date:

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


Re: postgres installed via rpms -can't run postmaster or postgres

From
Lamar Owen
Date:
On Saturday 18 October 2003 04:39 am, 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.

Well, Eric, you got some bad advice already.  I hope you didn't do most of it,
since the RPM installation does most of the hard things for you.  I know this
because I built the RPMs.  But I digress.

The RPM's are intended to make things simpler.  First, though, you need to get
a newer version than 7.3-2.  You really want to download the 7.3.4 RPMs,
since 7.3.4 has substantial bugfixes.

To get a running postgresql system with the RPMs, after installing the RPMs
(assuming you have postgresql-server installed), while you are still root (do
not su to postgres for this step, as the script you are about to run does
that for you), run '/sbin/service postgresql start'.  The 'service' command
(located in /sbin) on Red Hat Linux is the control program to start, stop,
and otherwise signal system processes.  It invokes the
/etc/rc.d/init.d/postgresql script packaged with the postgresql-server RPM.

The script automatically performs the proper initdb functions and starts the
postmaster as user postgres (the user and group named postgres were created
during the installation of the postgresql-server RPM by the RPM's post
installation script).  Once the postmaster is running (use the command 'ps
ax|grep postmaster' to see if the postmaster is running), you can su to the
postgres user (from root only, since you can't directly log in as that user,
unless you set its password) and run the commands you need to run.

> 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

The directory in which you execute the rpm command has nothing to do with
where the rpm is installed.  The locations for each of the files in the RPM
itself is set by the packager (in this case, me), and isn't selectable by the
installer, unless the packager has made the package relocatable (which the
postgresql RPMs aren't).

I am, however, somewhat dismayed by the amount of misinformation you already
have received.  My apologies for not replying sooner.

So, in summary, to get a running PostgreSQL installation with the RPM's
(assuming PostgreSQL is not already installed):
rpm -i postgresql*7.3.4*.rpm
/sbin/service postgresql start
su - postgres
createdb .......
createuser ......
psql .....
......

Hey, and I'm glad to see that you actually read the README.rpm-dist... :-)

--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC  28772
(828)862-5554
www.pari.edu