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.