Re: [GENERAL] Shell script to Backup/Dump Database

2010-05-12 Thread Thom Brown
On 12 May 2010 16:30, Andre Lopes wrote: > Hi, > > I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day. > > I will need to do a full dump (schema + data), schema dump (only schema) > and data (only data) > > There is something done on this subject? I'am very poor in shell scri

Re: [GENERAL] Shell script to Backup/Dump Database

2010-05-12 Thread Thom Brown
On 12 May 2010 17:02, Andre Lopes wrote: > Thanks for the reply. > > I will test today. > > There are some good practices that I should do? For example, I have this > database in a shared hosting, should I add the functionality of send the > dumps by FTP to my PC once a week? Give some more ideia

Re: [GENERAL] Shell script to Backup/Dump Database

2010-05-12 Thread Andre Lopes
Thanks for the reply. I will test today. There are some good practices that I should do? For example, I have this database in a shared hosting, should I add the functionality of send the dumps by FTP to my PC once a week? Give some more ideias to avoid data loss in case of disaster. Best Regards

Re: [GENERAL] Shell script to Backup/Dump Database

2010-05-12 Thread Thom Brown
On 12 May 2010 16:30, Andre Lopes wrote: > Hi, > > I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day. > > I will need to do a full dump (schema + data), schema dump (only schema) > and data (only data) > > There is something done on this subject? I'am very poor in shell scri

[GENERAL] Shell script to Backup/Dump Database

2010-05-12 Thread Andre Lopes
Hi, I'am looking fo a shell script do Backup/Dump my PostgreSQL twice a day. I will need to do a full dump (schema + data), schema dump (only schema) and data (only data) There is something done on this subject? I'am very poor in shell script, there are some scripts on the web ready to use? Be