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 want to create a quick clone of an existing database on a second machine - provided that the platform and postgresql version on there is identical to the source). The proper way would be to use pg_dump (a tool that comes along every postgresql installation - see the docs for usage), which will dump the data and structure. There is a second such utility program called pg_restore which will take the dump-file created with pg_dump and restore it to a database of your choosing. Those dumps will be functional between versions and platforms - so that's the way to go. UC On Saturday 01 July 2006 21:01, Joko Siswanto wrote: > 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 service is > shutdown. > > Where is postgresql put teh database files? > > Thanks all, > Jokonet -- Open Source Solutions 4U, LLC 1618 Kelly St Phone: +1 707 568 3056 Santa Rosa, CA 95401 Cell: +1 650 302 2405 United States Fax: +1 707 568 6416
