HOW-TO migrate database - Mailing list pgsql-admin

From Marian Sabo
Subject HOW-TO migrate database
Date
Msg-id 9j0rkk$1ugo$1@news.tht.net
Whole thread Raw
Responses Re: HOW-TO migrate database
List pgsql-admin
Hello

I have a many databases on server "one" in postgres-6.5.2

How can I copy my databases to a new server with new postgres vsersion
(7.1.2) ?

on first server I run : pg_dumpall -o > outputfile, but on new server
pg_restore don't understand the data format.

the same result is on pg_dump dbname > file and on second server pg_restore
file ...

How it is possible to copy all databases from one (6.5.2) to second (7.1.2)
server ?

Many thanks

Marian Sabo



pgsql-admin by date:

Previous
From: "Rommel B. Abaya"
Date:
Subject: Re: how to connect remote database
Next
From: "Dalibor Andzakovic"
Date:
Subject: rserv