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 [EMAIL PROTECTED] http://www.net6d.com
-- Bruno LEVEQUE System Engineer SARL NET6D [EMAIL PROTECTED] http://www.net6d.com
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings