Karl DeBisschop wrote: > Paul Tomblin wrote: >> >> Quoting Tom Lane ([EMAIL PROTECTED]): >> > Paul Tomblin <[EMAIL PROTECTED]> writes: >> > > I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system. >> > > I want the data directory on a separate partition, so I shut down, >> > > tar the whole directory into the other directory, mount it, and when >> > > I start up postgresSQL it says it's up, but I can't connect to any >> > > databases using psql. >> > > psql: connectDBStart() -- connect() failed: Connection refused >> > > Is the postmaster running locally >> > > and accepting connections on Unix socket >> > > '/tmp/.s.PGSQL.5432'? >> > > There is a postmaster running, but no socket in /tmp/ >> > >> > Odd. Seems unlikely that that has anything to do with your having >> > moved >> > the data directory. Any interesting messages in the postmaster log? >> > Can you connect via TCP? >> >> Is there a postmaster log other than what's in /var/log/messages? >> Because there is nothing useful in there other than a message that it >> started successfully. > > As for your original question, which I missed, I assume you set '-i' in > postmaster.opts.default. > > As for the log issue, you can also set log level in > postmaster.opts.default > What is the version of your Kernel? I'm running PSQL on a 2.2.16-Kernel without problems. When I updated to 2.4.0 I got problems. Postgres don't start, though I built it from the source. The error message is "IpcSemaphoreCreate: semget(key=1, num=17, 03600) failed: Function not implemented" The same message comes when I try to start new compiled Apache. But if you don't have 2.4-Kernel try this: PSQLPREFIX=/usr/local/pgsql rm -rf $PSQLPREFIX/data mkdir $PSQLPREFIX/data chown postgres.daemon $PSQLPREFIX/data su - postgres -c "$PSQLPREFIX/bin/initdb -D $PSQLPREFIX/data" Roland ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
