Postgresql Backup Question(Using WinSCP)
Posted on 2006-11-16
I currently backup our postgres database using pg_dump, which dumps it to a .sql file. I was wondering if I can simply copy the entire data folder which resides in /var/lib/postgres
If I copy that entire data folder using WinSCP, which also contains these folders(base, pg_xlog, pg_clog, and global) will this give me a complete backup of our database? The database resides on our Debian server, and I would be copying this folder to our Windows Domain server so I can back it up to tape.
Is this the best way to back things up?