[ADMIN] UNIX vs Windows LC CTYPE and UPPER mu

2012-04-18 Thread service prodat
Hello, first: i hope im right here in this mailing list. My problem: We have several Postgre servers 9.0.4, one on Windows Server 2008 R2 and others on different UNIX/Linux systems. Windows: LC_CTYPE = 'German, Germany' UNIX: LC_CTYPE='de_DE.UTF-8' (so LC_COLLATE is too) on both systems

Re: [ADMIN] invalid byte sequence for encoding UTF8: 0xf481 - how could this happen?

2012-04-18 Thread Rural Hunter
于 2012/4/17 18:06, Albe Laurenz 写道: Rural Hunter wrote: That's probably the problem - it seems to emit something that is not proper UTF-8 sometimes. Do you get the error if you try Chinese settings without nlpbamboo? How can I do this? The Chinese processing is provided by nlpbamboo. -- Sent

[ADMIN] Clarification on start/stop backup

2012-04-18 Thread Scott Whitney
I'll be moving to PG9 (hopefully soon...probably 6 weeks). At that time, I'll be setting up hot-standby with streaming replication to 2 sites. Off-siting my pgdumps nightly is no longer going to be possible in the very near future, due to the size of the dumps. So...what I had planned to do

[ADMIN] Cannot Connect To Db From Local Server

2012-04-18 Thread Rickard, David
We have a legacy PostgresSQL 7.3.4 db on Solaris which has recently (as in last 24 hours or so) begun refusing TCP/IP (JDBC) connections from the same server the db is on. The db is up and running-psql connects; I can access the db via pgAdmin III from a PC; I can connect via JDBC from a PC.

Re: [ADMIN] Cannot Connect To Db From Local Server

2012-04-18 Thread Scott Mead
On Wed, Apr 18, 2012 at 10:12 PM, Rickard, David drickard1...@library.ucla.edu wrote: We have a legacy PostgresSQL 7.3.4 db on Solaris which has recently (as in last 24 hours or so) begun refusing TCP/IP (JDBC) connections from the same server the db is on. The db is up and

Re: [ADMIN] Cannot Connect To Db From Local Server

2012-04-18 Thread Steve Crawford
On 04/18/2012 03:12 PM, Rickard, David wrote: We have a legacy PostgresSQL 7.3.4 db on Solaris That's not legacy, that's antique. I'm basing my commands on recent versions - if the options differed back then you may have to adjust. which has recently (as in last 24 hours or so) begun