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.
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 |