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