Hello there,
Once in awhile, as I am trying to run various versions of the Postgres DB
engine I get a message on startup indicating that my control file is not up
to snuff. Last time it happened with Postgres 9.1 on OpenIndiana 11.
So my questions are as follows:
1) Why does that generally happe
On Fri, Oct 26, 2012 at 12:46 PM, Tom Lane wrote:
> Boris Epstein writes:
> > The Postgres 8.4 would simply not shutdown for me. Don't know why:
>
> > Here's a snippet of /var/postgres/8.4/data_64/server.log seemingly
> > corresponding to these shutdown attempt
Hello listmates,
When I run the following:
postgres@zeus:~$ export PGDATA=/var/postgres/8.4/data_64/
postgres@zeus:~$ /usr/postgres/8.4/bin/amd64/pg_ctl stop
waiting for server to shut
down... failed
pg_ctl: server does not shut down
p
Hello listmates,
I am trying to move the data directory for this PG installation. So one
question would be, how do I do that? What's the accepted practice?
And if I want to split the storage - i.e., put databases into different
directories - can I do that?
At this point I tried to just move the
