Re: [GENERAL] big database with very small dump !?

2008-08-11 Thread Vlad Kosilov
I'd do du -sh /var/pgsql/data/base rather then /var/pgsql/data depending on how your pgsql server logging is setup, there are other folders and/or files that might take considerable disk space under ./data/ you may want to exclude those. I find this query useful for something like this as well:

[GENERAL] pgsql8.3.2 tentative release date

2008-06-05 Thread Vlad Kosilov
is there a tentative release date (week ... month) for postgres-8.3.2 ? Thanks! Vlad -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_standby stuck on a wal file size <16MB

2008-05-20 Thread Vlad Kosilov
er directory, you need some sort of test or locking to make sure the file is complete with exactly 16MB before it gets rsync'd over. I suspect no amount of poking at the standby will root out the issue because it's happening on the primary. -- * Greg Smith [EMAIL PROTECTED] http://www.gregs

[GENERAL] pg_standby gets stuck on a smaller wal file

2008-05-18 Thread Vlad Kosilov
l5 #1 SMP Tue Jul 10 06:39:17 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux Thanks much in advance V. -- Vladimir (Vlad) Kosilov Senior Systems Administrator Contigo Systems Inc. 604.683.3106 (phone) 604.648.9886 (fax) [EMAIL PROTECTED] www.contigo.com __

Re: [GENERAL] pg_standby stuck on a wal file size <16MB

2008-05-17 Thread Vlad Kosilov
e sure the file is complete with exactly 16MB before it gets rsync'd over. I suspect no amount of poking at the standby will root out the issue because it's happening on the primary. -- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD -- __

Re: [GENERAL] pg_standby stuck on a wal file size <16MB

2008-05-17 Thread Vlad Kosilov
remember in the C code checks for complete segment sizes. thanks Ioannis Tambouras -- ____ Vladimir (Vlad) Kosilov Senior Systems Administrator Contigo Systems Inc. 604.683.3106 (phone) 604.648.9886 (fax) [EMAIL PRO

Re: [GENERAL] pg_standby stuck on a wal file size <16MB

2008-05-17 Thread Vlad Kosilov
before with mixed results on a writes busy db and linux/nfs Thanks, V. -- ________ Vladimir (Vlad) Kosilov Senior Systems Administrator Contigo Systems Inc. 604.683.3106 (phone) 604.648.9886 (fax) [EMAIL PROTECTED] www.contigo.com ___