From: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Why can't I do this (setup question) |
Date: | 2001-05-20 00:42:05 |
Message-ID: | 20010519204205.A4429@allhats.xcski.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
Here's the whole sequence of commands as root:
mkdir data.new
chown postgres.postgres data.new
mount /dev/hdc6 data.new
cd data.new
(cd ../data; tar cvBf - .) | tar xvBpf -
cd ..
mv data data.old
umount data.new
mkdir data
chown postgres.postgres data
mount /dev/hdc6 data
/etc/rc.d/init.d/postgresql start
Is there a way to make this work, or am I going to have to export and
import?
--
Paul Tomblin <ptomblin(at)xcski(dot)com>, not speaking for anybody
Command, n.:
Statement presented by a human and accepted by a computer in
such a manner as to make the human feel as if he is in control.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-20 04:38:17 | Re: Why can't I do this (setup question) |
Previous Message | Tom Lane | 2001-05-20 00:28:15 | Re: Compiling for Caldera |