[ADMIN] Incremental backup

2005-05-13 Thread Michael Kichanov
Hi All! I wish to realize incremental backup, i.e. to dump only those tables which have changed from last backup. 1q. How i can solve this task with internal postgres tools? 2q. How I can to find out timestamp of last change of the table? Does anyone resolve this things? Ps: postgres 7.3 Thanx

[ADMIN] Incremental backup

2005-05-17 Thread Michael Kichanov
Hi All! I wish to realize incremental backup, i.e. to dump only those tables which have changed from last backup. 1q. How i can solve this task with internal postges tools? 2q. How I can to find out timestamp of last change of the table? Does anyone resolve this things? Ps: postgres 7.3 Thanx

[ADMIN] Changing the encoding of the database on the fly

2006-05-31 Thread Michael Kichanov
Hi All! Can i change the encoding of the database with "update pg_database set encoding= where datname=" without any problem with DB integrity? Thanx in advance! ---(end of broadcast)--- TIP 4: Have you searched our list archives?