HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Save postgres database from broken ubuntu 10.04 server

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresubuntubrokendatabasesaveserverfrom

Problem

Recently a database server with an important db broke (some grub linux issue that I'd prefer not to solve).

I can still access the filesystem. Is there a chance to transfer the database by only moving some directories with content to an equal machine?

This is a 32 bit ubuntu 10.04 with postgres 8.4

Edit: On ubuntu 10,04 the postgresql data directory is /var/lib/postgresql/8.4/main and not /usr/local/pgsql/data

Solution

I think backing up the "data directory" is what you want.

Moving the whole directory to a new server should be what you might look into. This will move everything within the cluster. From there, you can drop, move,... your single databases as you need to.

Context

StackExchange Database Administrators Q#3204, answer score: 8

Revisions (0)

No revisions yet.