Re: Help! Upgrade to 8.4 dropped my databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Andrew Perrin wrote:

> 1.) Is there a way to "reconnect" the 8.3 server, after reinstalling
> it, to the raw files, so that the databases are there? I will then
> do a pg_upgradecluster and be happy; or, alternatively,

If you're in a hurry, just install 8.3 from source and run postmaster -D
/path/to/data/files (be sure to choose a nonconflicting port).  Then you
can connect to it with pg_dump and get the data out and into the 8.4
installation.

Oh, make sure you keep an eye out for the socket directory too ...
default PG places sockets in /tmp whereas Debian places them in
/var/run/postgresql.  Just in case.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux