Thanks for all,It's really help me, I mean that give me a lot of clueBtw,
Now I still reinstall the postgres coz i dont know why suddenly i can't
start the services. that's why i ask how to backup the data when the
serviceis down.
I'll try it and thanks for helpRegard,Jokonet
On Sunday 02 July 2006 01:42, Tino Wildenhain wrote:
> Uwe C. Schroeder wrote:
> > You can technically just copy & paste the postgresql data directory IF
> > YOU SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for
> > the same version of postgresql. Also: this is not a good way to
Uwe C. Schroeder wrote:
> You can technically just copy & paste the postgresql data directory IF YOU
> SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
> same version of postgresql. Also: this is not a good way to do it and I'd
> encourage you not to use this as general
You can technically just copy & paste the postgresql data directory IF YOU
SHUT DOWN THE POSTMASTER FIRST! Be aware that this will only work for the
same version of postgresql. Also: this is not a good way to do it and I'd
encourage you not to use this as general means of backup (it's ok if you
On windows the database files are under C:\program files\postgresql\8.1
\data
There are a number of different ways a backup can be done and a file
level copy/paste is one of them.
See http://www.postgresql.org/docs/8.1/interactive/backup.html
Mike
On Sun, 2006-07-02 at 11:01 +0700, Joko Siswant
> 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 wh
Hi all,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
