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

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

From
"Eric M. Wulff"
Date:
This is very helpful.  My next problem is setting up a db.  createdb fails...

"psql: FATAL:  user "blah" does not exist
createdb: database creation failed"

The user is either myself or root.  Of course, doesn't like root.   How
do I get psql to recognize me as a user.

fyi - I'm on redhat 8.0.  Can anyone refer me to documentation for
configuring if installed via rpm?  The docs on postgres.org seem to refer
to deeper darker operations than I need.  The README.rpm-dist alluded that
might need to set the config file for tcpip.  Did that. Still didn't help.
Redhat is more often refereeing to Red Hat db.  I am missing something.Also,
I have now studied the server start script somewhat but that hasn't shed
any light on the issue either.

thx much
Eric


> On Sat, 2003-10-18 at 10:42, Mailing List 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.
> >
> > If you installed via RPMS you're probably using Red Hat Linux (or
> > something similar). Then you should rely on your OS' startup script.
> > As root give:
> >
> >   /etc/rc.d/init.d/postgresql start
> >
> > to start your PostgreSQL server.
> >
> >
> > > 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?
> >
> > It is not, apperantly...
> >
> >
> > > 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."
> >
> > Look at Red Hat's startup script: without the environment variables
> > defined therein the postmaster is lost...
> >
> >
> > > 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
> >
> > RPMs install at locations specified in the packages. You can't really
> > influence that (ok, you can, but you need to know what you are doing...)
> >
> >
> > Bye, Chris.
> >
> >
>



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

From
Mailing List
Date:
On Sat, 2003-10-18 at 22:15, Eric M. Wulff wrote:
> This is very helpful.  My next problem is setting up a db.  createdb fails...
>
> "psql: FATAL:  user "blah" does not exist
> createdb: database creation failed"
>
> The user is either myself or root.  Of course, doesn't like root.   How
> do I get psql to recognize me as a user.

As root become the user postgres by giving:
  su - postgres
Now create a postgres user named after your normal OS user account (blah
I guess?):
  createuser blah
(createuser is a postgres command). If you answer yes to the question
whether the new user should be able to create DBs your done. Now as OS
user blah you can do a createdb.

Bye, Chris.



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

From
"mathan"
Date:
Hai Eric

Try the following, let me know if you have any doubts

1. To start postmaster you must be logged in to your PostgreSQL server
   account( postgres). It will not work as root.
create the data dir (eg: /var/postgresql/data)

 # mkdir /var/postgresql/data
 # chown postgres /var/postgresql/data

 create the user "postgres"

        # su - postgres

        $ initdb -D /var/postgresql/data

        $ postmaster -i -D /var/postgresql/data

      This will start the server in the background.

      To stop a server running in the background you can type

        $ kill `cat /var/postgresql/data/postmaster.pid`

 In order to allow TCP/IP connections (rather than only Unix domain socket
ones) you need to pass the "-i" option to "postmaster".

3.   Create a database:

 create a database named 'db'

        $ createdb db

4.   To view the database created, use the following command:

 $ psql -l

 Now postgresql is running, we can view the PID by using the
 following command

 $ ps -ef | grep postmaster

 Then enter

        $ psql db

       Above rule should prompt to database db as
       Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

 db=#

thanks
mathan

----- Original Message -----
From: "Eric M. Wulff" <ewulff@footbag.org>
To: <bruno.leveque@net6d.com>; <pgsql-admin@postgresql.org>
Sent: Sunday, October 19, 2003 1:45 AM
Subject: Re: [ADMIN] postgres installed via rpms -can't run postmaster or


> This is very helpful.  My next problem is setting up a db.  createdb
fails...
>
> "psql: FATAL:  user "blah" does not exist
> createdb: database creation failed"
>
> The user is either myself or root.  Of course, doesn't like root.   How
> do I get psql to recognize me as a user.
>
> fyi - I'm on redhat 8.0.  Can anyone refer me to documentation for
> configuring if installed via rpm?  The docs on postgres.org seem to refer
> to deeper darker operations than I need.  The README.rpm-dist alluded that
> might need to set the config file for tcpip.  Did that. Still didn't help.
> Redhat is more often refereeing to Red Hat db.  I am missing
something.Also,
> I have now studied the server start script somewhat but that hasn't shed
> any light on the issue either.
>
> thx much
> Eric
>
>
> > On Sat, 2003-10-18 at 10:42, Mailing List 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.
> > >
> > > If you installed via RPMS you're probably using Red Hat Linux (or
> > > something similar). Then you should rely on your OS' startup script.
> > > As root give:
> > >
> > >   /etc/rc.d/init.d/postgresql start
> > >
> > > to start your PostgreSQL server.
> > >
> > >
> > > > 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?
> > >
> > > It is not, apperantly...
> > >
> > >
> > > > 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."
> > >
> > > Look at Red Hat's startup script: without the environment variables
> > > defined therein the postmaster is lost...
> > >
> > >
> > > > 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
> > >
> > > RPMs install at locations specified in the packages. You can't really
> > > influence that (ok, you can, but you need to know what you are
doing...)
> > >
> > >
> > > Bye, Chris.
> > >
> > >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003