Re: [ADMIN] Consulta about BACKUP DB

[[EMAIL PROTECTED]]

pg_dump -Dn databasename > mybackupdatabasename.sql

to restore:

create databasename_new
psql -e databasename_new < mybackupdatabasename_new.sql

more information man pg_dump

regards

On Fri, 2 Feb 2001 [EMAIL PROTECTED] wrote:

{Hi all,
{
{I going to cahge machine, but I need to make backup of my database, my
{version of postgresql is: 6.5.3 now my version will be 7.0.
{
{How can I to make the backup of tables, index and data?
{
{Thanks in advanced.
{
{
{