Re: [ADMIN] question about HA in PG 9.0

2010-09-18 Thread Thomas Kellerer
Kasia Tuszynska wrote on 18.09.2010 01:30: 1. The doc is lovely but all of the examples are for linux, has anyone tired a Hot Standby streaming scenario on windows? Any issues specific to windows? I know that linux and windows environments “should” behave the same but actually running in both of

Re: [ADMIN] files under pg_clog directories are missing

2010-09-18 Thread Greg Smith
Scott Marlowe wrote: As a followup to all this, the OP also needs to figure out why a crashed server could cause so much corruption. This is usually the result of hardware lying about fsync status, i.e. consumer grade hardware pressed into service as a server. See

[ADMIN] management of pg-schemas: pg_temp_n and pg_toast_n ?

2010-09-18 Thread Mark Rostron
This is occurring In an 8.4.2 pg database, and I have noticed it in 8.3.10 as well. We do a lot of work with temp tables here, and over time a lot of pg_temp_[n] schemas have appeared. Similarly, we notice build-up of pg_toast_[n] schemas. Is it ok to drop these if they contain no tables? Or is

Re: [ADMIN] management of pg-schemas: pg_temp_n and pg_toast_n ?

2010-09-18 Thread Tom Lane
Mark Rostron mrost...@ql2.com writes: We do a lot of work with temp tables here, and over time a lot of pg_temp_[n] schemas have appeared. Similarly, we notice build-up of pg_toast_[n] schemas. This is expected. There'll be one for each backend slot that's ever used any temp tables. Is it