Re: [ADMIN] Help installing 8.0.2 rpms on RH 3.0

2005-04-14 Thread Tom Lane
"Chris Hoover" <[EMAIL PROTECTED]> writes: > ... However, I am having some difficulty installing the > postgresql.org RH 3.0 rpms for Postgresql 8.0.2. Up until really recently (read: not yet shipped for Red Hat, and I'm not sure about the PGDG RPMs), the 8.0 RPMs had the wrong Obsoletes: data in

Re: [ADMIN] PostgreSQL replication solution?

2005-04-14 Thread Andrei Bintintan
The scenario is the following: I have a main database on a server probably this will be the master. With this replication we want first to make a copy of this database which will be at another location(another company) with 1 time/day sincronization, so this will be a slave which will contain a p

[ADMIN] unsubscribe

2005-04-14 Thread Patricia Megumi Matsumoto
unsubscribe -- Patricia Megumi Matsumoto <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] brute force attacking the password

2005-04-14 Thread Wim Bertels
LS, is there a way of securing the postgresql-server against brute force password cracking ? iow: is there a way of setting eg a maximum number of login attempts, or using a time-out or ..? + securing on server level tnx, ---(end of broadcast)--- T

[ADMIN] unsubscribe

2005-04-14 Thread Noel Salles
unsubscribe ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Help installing 8.0.2 rpms on RH 3.0

2005-04-14 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, You need to build all software that runs with PostgreSQL. On my RHEL box, I've just symlinked libpq.so.4 to libpq.so.3 manually. Apply the same procedures for libecpg.so.4 and libpgtypes.so.1 . Regards, On Wed, 13 Apr 2005, Chris Hoover wrote: I n

[ADMIN] performance problem

2005-04-14 Thread sanjay tumula
looks like reducing shared_buffers and turning off archiving might be helping...i will post a followup in a few days... kind of disappointed that no one bothered to reply yet though. ---(end of broadcast)--- TIP 6: Have you searched our list archive

Re: [ADMIN] Help installing 8.0.2 rpms on RH 3.0

2005-04-14 Thread Geoffrey
Devrim GUNDUZ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, You need to build all software that runs with PostgreSQL. Can you justify this statement with experiences? -- Until later, Geoffrey ---(end of broadcast)--- TIP 4: Don't 'kill -9'

Re: [ADMIN] Help installing 8.0.2 rpms on RH 3.0

2005-04-14 Thread Devrim GUNDUZ
Hi, On Thu, 14 Apr 2005, Geoffrey wrote: You need to build all software that runs with PostgreSQL. Can you justify this statement with experiences? Sure. On my RHEL4 test box, I recompiled PHP from SRPM so that it will use libpq.so.4. I have some more apps that requires PostgreSQL at the backend,

[ADMIN] Patch d4dsize Needed

2005-04-14 Thread Jack Xue
Hi, there, I am a postgres 8.0 user. I need the function pg_relation_size in dbsize patch. Where I can get it? An email attachment is preferred. This is the first time I apply a patch to postgres. Please give me detailed instruction. Thanks. Yours Jack ---(end of bro

[ADMIN] Support for raster Data

2005-04-14 Thread gayatri ganpaa
Hi,   I do not know if I am mailing ot the right group, but does PostGIS have support for raster data? If so, how to acheve this?   Thanks, gayatri.__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[ADMIN] Latest pg_autovacuum script

2005-04-14 Thread Theo Galanakis
Title: Latest pg_autovacuum script Hi,     I have updated the pg_autovacuum script with some bug fixes and changes. Hope you find this useful. -- This goes where all the other init scripts are located. -- Can be placed at the top of /etc/rc.d/init.d/postgresql script or in the /etc/sysc