Re: [ADMIN] PostgreSQL and ZFS

2008-09-03 Thread Larry Rosenman
I'm running on ZFS on a lightly loaded FreeBSD 7 box, and it's fine. I did give ZFS the hint with recordsize=8K on the data directory/fs, but nothing else. (other than the usual caveats with ZFS on FreeBSD (I'm on amd64)). LER -- Larry Rosenman http://www.le

Re: [ADMIN] SSL problems

2008-09-03 Thread Jan-Peter Seifert
Hello Andriy, the reply-to settings are a bit uncomfortable here. Your mail went only to me. But I'm not part of the developer or support team. It's strange that pg_ctl doesn't say anything else. Is there any system sniffer on FreeBSD like Process Monitor on Windows? I can only say that the docs w

Re: [ADMIN] Database encoding

2008-09-03 Thread Jeremy Tunnell
The setting is in a file called i18n, but I can't recall where it's located. On Wed, Sep 3, 2008 at 6:40 AM, Anibal David Acosta <[EMAIL PROTECTED]>wrote: > Hello, I have a postgresql installed with encoding "WIN1252". > > > > But I need to create a DB with LATIN1 encoding, when I try I got the

Re: [ADMIN] SSL problems

2008-09-03 Thread Tom Lane
Andriy Bakay <[EMAIL PROTECTED]> writes: > I have problems to setup SSL for PostgreSQL server. I did all the steps > which described in the documentation (17.8. Secure TCP/IP Connections > with SSL), but when I try to start the PostgreSQL server the pg_ctl gave > me: "could not start server". And n

[ADMIN] rpm install not recognized by yum.

2008-09-03 Thread slamp slamp
one of our servers had the pgdg rpms (8.2.4) installed by hand. now that the yum repo is available, i installed pgdg-redhat-8.2-4.noarch.rpm. this is on redhat-release-5Server-5.2.0.4. i do a yum update and the rpms are not being recognized. how come? also when i performed yum clean all i get the m

[ADMIN] PostgreSQL and ZFS

2008-09-03 Thread Thomas Bräutigam
Hello all, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS?

[ADMIN] SSL problems

2008-09-03 Thread Andriy Bakay
Hi Team, I have problems to setup SSL for PostgreSQL server. I did all the steps which described in the documentation (17.8. Secure TCP/IP Connections with SSL), but when I try to start the PostgreSQL server the pg_ctl gave me: "could not start server". And nothing in the logs (I enabled all o

[ADMIN] Database encoding

2008-09-03 Thread Anibal David Acosta
Hello, I have a postgresql installed with encoding "WIN1252". But I need to create a DB with LATIN1 encoding, when I try I got the error: "Encoding Latin1 does not match server's locale Spanish_Spain.1252. The servers's LC_CTYPE setting require encoding WIN1252 Is possible to change the

[ADMIN] PostgreSQL and ZFS

2008-09-03 Thread Thomas Bräutigam
Hello, I am working with a PostgreSQL Database and I want to change the Filesystem to ZFS. Does someone have experience with PostgreSQL and its Performance with ZFS? Are the current write options for PostgreSQL suitable for ZFS? Do I need to finetune Postgres with the settings for ZFS? Like

[ADMIN] SSL problems

2008-09-03 Thread Andriy Bakay
Hi Team, I have problems to setup SSL for PostgreSQL server. I did all the steps which described in the documentation (17.8. Secure TCP/IP Connections with SSL), but when I try to start the PostgreSQL server the pg_ctl gave me: "could not start server". And nothing in the logs (I enabled all of t

[ADMIN] server/db encoding (mix) issues

2008-09-03 Thread Jan-Peter Seifert
Hello, we have a mix of older software still using LATIN1 as db encoding and the psqlODBC-drivers (ANSI) and newer software using UTF8 as db encoding. As running two server instances would use up more resources(?) than just one we'd like to have all dbs in one cluster. Which cons against this s

[ADMIN] pg_dump etc. versions

2008-09-03 Thread Jan-Peter Seifert
Hello, I'm wondering if there's a compatibility list of the tools supplied with PostgreSQL - e.g. psql seems to be very server version specific (only major or also minor versions?). For pg_dump I'd say users should use the version of the target server if it's already installed, but is this also

Re: [ADMIN] Configure DB

2008-09-03 Thread Jan-Peter Seifert
Hi, > Datum: Mon, 1 Sep 2008 11:40:29 +0530 > Von: Vishal Arora <[EMAIL PROTECTED]> > Betreff: Re: [ADMIN] Configure DB > Date: Sat, 30 Aug 2008 11:42:57 -0500From: [EMAIL PROTECTED]: > [EMAIL PROTECTED]: [ADMIN] Configure DB > Hi List, I'm working with Postgres, I'm storing spatial information