Thread: Updates to my PostgreSQL Wiki
I've got some new content on my wiki for PostgreSQL. http://www.bluwiki.org/go/PostgreSQL_Tips_From_The_Sunburned_Surveyor You will find an article on making connections to the PostgreSQL server, and an article on creating automated backups of PostgreSQL databases using a bash shell script. These are two areas I didn't find much info on as a newbie. I managed to work through them with some help and wanted to post my solutions for other PostgreSQL/Linux newbies. If more experienced users read over the articles and find mistakes or something that could be imporved, please let me know. I hope others in the community will benefit from the articles. The Sunburned Surveyor P.S. - I still have some sections to complete on the article about automatic backups. I was also wondering, what is the -c switch used for? What type of custom format would you export in a postgreSQL backup?
On Mar 4, 2006, at 7:04 , Redefined Horizons wrote: > P.S. - I still have some sections to complete on the article about > automatic backups. I was also wondering, what is the -c switch used > for? What type of custom format would you export in a postgreSQL > backup? Are you referring to the -Fc flag for pg_dump? Something that I was recently made aware of was this[1]: > Output a custom archive suitable for input into pg_restore. This is > the most flexible format in that it allows reordering of loading > data as well as object definitions. This format is also compressed > by default. You can use the --list and --use-list flags for pg_restore[2] to take advantage of the custom format dump file. Hope this helps. Michael Glaesemann grzm myrealbox com [1](http://www.postgresql.org/docs/current/interactive/app-pgdump.html) [2](http://www.postgresql.org/docs/current/interactive/app- pgrestore.html)
On Friday 03 March 2006 23:04, Redefined Horizons wrote: >I've got some new content on my wiki for PostgreSQL. > >http://www.bluwiki.org/go/PostgreSQL_Tips_From_The_Sunburned_Surveyor > >You will find an article on making connections to the PostgreSQL >server, and an article on creating automated backups of PostgreSQL >databases using a bash shell script. I think you have a typo in the nowDate declaration. It should read: declare nowDate=$(date +%F) -- Leif Biberg Kristensen | Registered Linux User #338009 http://solumslekt.org/ | Cruising with Gentoo/KDE