Re: [ADMIN] File system backup question

2006-08-08 Thread Jim Nasby
cause the restore to fail. I will try it as well as a file system restore. -Original Message- From: Joshua D. Drake <[EMAIL PROTECTED]> To: Benjamin Krajmalnik <[EMAIL PROTECTED]> CC: pgsql-admin@postgresql.org Sent: Thu Aug 03 21:01:54 2006 Subject: Re: [ADMIN] File system bac

Re: [ADMIN] File system backup question

2006-08-03 Thread Benjamin Krajmalnik
Title: Re: [ADMIN] File system backup question I believe I have to use onserts due to the problem with the records with the improper utf encoding.  According to the docs this will cause the restore to fail. I will try it as well as a file system restore. -Original Message

Re: [ADMIN] File system backup question

2006-08-03 Thread Joshua D. Drake
Benjamin Krajmalnik wrote: I am currently running PG 8.1.4 windows. The system is for a real time monitoring application (so downtime needs to be minimized if at all possible). I will be migratng to a new server running PG 8.1.4 on FreeBSD 6.1. I have been playing with various options for migr