Re: [ADMIN] Problem with pgstat timeouts

2012-01-04 Thread Benjamin Krajmalnik
Just a followup - thanks to Tom, Kevin, and the rest of the user group, as usual, for their great support. It appears that I have hit a nice firmware bug, so I am going to have to upgrade the controller firmware. Apparently, it has some issues communicating with the BBU so although the BBU is s

[ADMIN] LDAP SSL authentication no longer supported in 8.4.8

2012-01-04 Thread Tim Olvey
Hi, I have been attempting to get our 8.4.8 database authenticating via a SunOne LDAP server using the older SSL encryption rather than TLS. The SSL compatibility no longer appears to be supported. I've seen some development efforts targeted at adding this compatibility back in with a patch. Can

Re: [ADMIN] Cannot restore dumps made with -Fc and --column-inserts

2012-01-04 Thread Dick Visser
On 4 January 2012 19:14, Tom Lane wrote: > Dick Visser writes: >> Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today. >> When I do a pg_dump using --column-inserts, the subsequent restore fails: > > Ugh ... I think I broke this :-(. > > As a workaround, you can ask pg_restore for plain text o

Re: [ADMIN] List archives dead?

2012-01-04 Thread Dick Visser
Hm. I swear there was a directory listing a few hours ago. I searched on Google and any links deeper in that web server gave me a 404. But nevermind, it is online again. On 4 January 2012 17:33, Tom Lane wrote: > Dick Visser writes: >> The archive lists web server seems to have been reinstalle

Re: [ADMIN] Problem with pgstat timeouts

2012-01-04 Thread Benjamin Krajmalnik
Batteries are installed and healthy. I wonder if it did it during one of the charge/discharge cycles and just did not revert (interestingly, I have one more server that did just that). I am trying to get the info from LSI as to what may have caused it, if it is safe to revert the cache mode wh

Re: [ADMIN] Problem with pgstat timeouts

2012-01-04 Thread Kevin Grittner
"Benjamin Krajmalnik" wrote: > Default Cache Policy: WriteBack, ReadAhead, Direct, No Write Cache > if Bad BBU > Current Cache Policy: WriteThrough, ReadAhead, Direct, No Write > Cache if Bad BBU > Is it possible that the WriteThrough is what is causing the high > io (and maybe the pgstat

Re: [ADMIN] Cannot restore dumps made with -Fc and --column-inserts

2012-01-04 Thread Tom Lane
Dick Visser writes: > Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today. > When I do a pg_dump using --column-inserts, the subsequent restore fails: Ugh ... I think I broke this :-(. As a workaround, you can ask pg_restore for plain text output and pipe that to psql.

Re: [ADMIN] Problem with pgstat timeouts

2012-01-04 Thread Benjamin Krajmalnik
I have proceeded to do some more checking, and I see in iostat that the pg_xlog drive has a significantly higher busy state than before. Whereas it was barely busy when we first spun up the server (total %busy since we started the server is about 6%) it is now in its 80's almost steady state.

Re: [ADMIN] List archives dead?

2012-01-04 Thread Tom Lane
Dick Visser writes: > The archive lists web server seems to have been reinstalled or > something, there is no content any more, just an empty Lighty page > from old years day: > http://archives.postgresql.org/ works for me ... regards, tom lane -- Sent via pgsql-admin m

[ADMIN] invalid byte sequence for encoding "UTF8": 0xf480

2012-01-04 Thread Rural Hunter
My db is in UTF-8 encoding. When I tried to generate gist index for some rows I got the strange error: select to_tsvector('chinesecfg',content) from article where article_id=23834922; ERROR: invalid byte sequence for encoding "UTF8": 0xf480 However, "select content from article where article_id

[ADMIN] List archives dead?

2012-01-04 Thread Dick Visser
The archive lists web server seems to have been reinstalled or something, there is no content any more, just an empty Lighty page from old years day: http://archives.postgresql.org/ No announcement on the Postgres homepage... is this scheduled maintenance? -- Dick Visser System & Networking E

Re: [ADMIN] Cannot restore dumps made with -Fc and --column-inserts

2012-01-04 Thread French, Martin
As far as I am aware, you're right and they ARE mutally exclusive. Cheers -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Dick Visser Sent: 04 January 2012 08:26 To: pgsql-admin@postgresql.org Subject: [ADMIN] Cannot resto

[ADMIN] Cannot restore dumps made with -Fc and --column-inserts

2012-01-04 Thread Dick Visser
Hi guys Running pg on Ubuntu 10.04 64bit, which is 8.4.9 today. When I do a pg_dump using --column-inserts, the subsequent restore fails: postgres@filesender:~$ pg_dump -Fc --column-inserts filesender -f filesender_backup.pgdump postgres@filesender:~$ createdb -T template0 fstest postgres@filesen