On Oct 15, 2012, at 2:27 AM, Tom Lane wrote:
> Tore Halset writes:
>> On this box I drop a 80GB database each night followed by a restore of a
>> similar sized database. It is a restore of our production database to a
>> development server. This box is running 9.2rc1 (so
22536 0.0 0.0 7372 880 pts/0S+ 23:36 0:00 grep 28573
postgres 28573 0.0 0.2 61372 38048 ?Ss Sep07 44:34 postgres:
autovacuum launcher process
Regards,
Tore Halset.
--
Sent via pgsql-admin mailing list (pgsql-admin
Hello.
Thanks a lot! Using the script, I found the entries with invalid UTF-8
and fixed them in the database.
- Tore.
On Sep 19, 2008, at 15:37 , Mikel Lindsaar wrote:
On Fri, Sep 19, 2008 at 6:29 PM, Tore Halset <[EMAIL PROTECTED]>
wrote:
Looks like I have managed to insert an i
Hello.
I am having some trouble restoring a dump from the production system
over to a test system. Both servers are 8.2.5 and both use UTF-8. The
vrc_error table have ~36 mill rows on the production system, but none
of those are restored to the test system.
pg_restore: [archiver (db)] Err
On Feb 15, 2008, at 10:17 , Tore Halset wrote:
Hello.
I have just moved our database from one server to another using warm
standby. It worked very well.
The setup: PostgreSQL 8.2.5 on Ubuntu. One partition for OS, one for
backup including wal archiving, one for base and one for pg_xlog
Hello.
I have just moved our database from one server to another using warm
standby. It worked very well.
The setup: PostgreSQL 8.2.5 on Ubuntu. One partition for OS, one for
backup including wal archiving, one for base and one for pg_xlog. It
is set up to archive wals to /backup/masterho
On Oct 1, 2004, at 10:12, Tore Halset wrote:
I am running 8.0.0-beta3 on Mac OS X 10.3.5 and 8.0.0-beta2-dev3
(pginstaller) on windows 2000. I have two databases. The dumpfile
(format c) for database 1 is 150MB and the dumpfile for database 2 is
2GB.
Dumping the databases on the mac worked. I
Hello.
I am running 8.0.0-beta3 on Mac OS X 10.3.5 and 8.0.0-beta2-dev3
(pginstaller) on windows 2000. I have two databases. The dumpfile
(format c) for database 1 is 150MB and the dumpfile for database 2 is
2GB.
Dumping the databases on the mac worked. I have loaded the dumpfiles in
another d
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
