Juan,
After performing the Dump/Import for the upgrade once it's cake. There
are two utilities that you can use
pg_dump
to dump data
psql < [file]
to restore
so before I upgrade I simply
pg_dump [options] [dbname]
to my archive/backup file
then after the upgrade I say
psql [options] < [archive.file]
and then go smoke (smoking is a bad habit) when I come back all my data is
there.
There are other options as well see the linked document about backup and
restore...it's really not that scary ;)
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=backup.html
/B
----- Original Message -----
From: "Juan Nin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 11:19
Subject: Re: MySQL vs. PostgreSQL
> From: "David Busby" <[EMAIL PROTECTED]>
>
> > I've always loved PostgreSQL I use it for large and small projects, with
> > some real nasty/ugly nested queries. It still performs great even under
> > some heavy load. Make sure you get a real (real) fast HDD (LVD SCSI 15K
> > RPM), the slower the drive the slower the database in my experience.
>
> thanks David
> and what about upgrading?
>
> I've heared that upgrading is more painfull with PostgreSQL, since you
have
> to dump the databases and restore them again after the upgrade
>
> is that true, or are there any new methods of upgrading?
>
> thanks again,
>
> Juan
>
>
>
> --
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]
> https://listman.redhat.com/mailman/listinfo/redhat-list
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
