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-
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
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 migrating the data. The d
We occasionally get the "file changed while being read" error, usually
only once or twice a month (and we run nightly backups.) It's nothing
to be concerned about, as someone else mentioned, the WAL logs will fix
any internal inconsistencies.
Regarding the file sizes, because it's zipped (I b
Another thing that conerns me is that the zipped file size keeps changing.
I'm backing up 10GB total. One night the backup file was 9 GB, one night it
was 874 MB and just now, 5 GB. I'm expecting a file around 1.5 GB (15% of
the 10GB) that's there.
---(end of broa
Hi Marco/all,
Thanks for the response. I've been running the same online-backup commands
for over a year and restores have always worked fine. I've never seen 'file
changed as we read it' though, before yesterday. The database is new to
the server, as of a week. So, I'm more inclined to
Hi,
Thanks for your check list. It's helpful with me.
-Javanesevn
Shoaib Mir wrote:
Have a look at http://www.powerpostgresql.com/PerfList/
and change your settings accordingly.
Thanks,
--
Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)
On 8/1/06, Javanesevn
<[EMAIL PROTECTED]>
wrote
