Re: How to Backup like in mysql or ms sql server

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Joko Siswanto <jokonet(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to Backup like in mysql or ms sql server
Date: 2006-07-02 04:17:54
Message-ID: 20060702041754.17510.qmail@web31804.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I'm new bie in postgresql.
> I use postgresql 8.1 windows version.
> How to back-up database in postgresql? Usually i use pgAdmin III by back-up
> and restore.
> Is there any way to back-up database like mysql or sql server we just copy
> and paste. Or maybe there is any tools to copy database when the service is
> shutdown.
>
> Where is postgresql put teh database files?

I am not sure about mysql or sql Server, but the following link will how how it is done on the
command line of the PostgreSQL server:
http://www.postgresql.org/docs/8.1/interactive/backup.html

Is is a good place to start. Also, if you are interested in keeping your data backed up current
within the last few minutes, check out point in time recovery (PITR). But for simple backup and
restore, I expect that you will be satisfied with the simple pg_dump command.

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Uwe C. Schroeder 2006-07-02 04:19:47 Re: How to Backup like in mysql or ms sql server
Previous Message mike 2006-07-02 04:14:11 Re: How to Backup like in mysql or ms sql server