[ADMIN] DB replicators comparison; (vs. DB upgrade via pg_dump)

2005-05-14 Thread ogjunk-pgjedan
Hello, I am about to upgrade from 7.3.4 to 8.0.3, and I read that using a DB replication tool is a good way to go about it. I see there are multiple replicator choices: Slony-I Daffodil Replicator Mammoth Replicator I was wondering if anyone has tried any 2 or 3 of them, and could share th

Re: [ADMIN] PGDG RPMS and integer-datetimes support

2005-05-14 Thread S Murthy Kambhampaty
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Because almost nobody has complained about the lack > of it. > (I'm talking about actual field experience of there > being a > problem, not somebody objecting that it sounds like > a > feature worth having.) > > It should also be pointed out that we are s

Re: [ADMIN] PGDG RPMS and integer-datetimes support

2005-05-14 Thread Tom Lane
S Murthy Kambhampaty <[EMAIL PROTECTED]> writes: > "Consistent precision through the range of allowed > values" sceems a feature worth having. > I wonder why you are "not sure that many people need > it". Because almost nobody has complained about the lack of it. (I'm talking about actual field e

Re: [ADMIN] IMPORTANT: two new PostgreSQL security problems found

2005-05-14 Thread Tomaz Borstnar
Thomas F.O'Connell wrote: I put together a little Perl script (which assumes proper installation of both DBI and DBD::Pg and that template1 exists) that takes care of the character conversion vulnerability: dont hardcode pgsql superuser :) Tomaž ---(end of broadcast)--

[ADMIN] Config option log_statement

2005-05-14 Thread S Murthy Kambhampaty
In postgresql 8.0, "create table <> as ..." statements appear not to logged unless log_statement = 'all' in postgresql.conf. We are trying to reduce noise in the logs from pgAdminIII and phpPgAdmin, but we use a lot of 'create table <> as ...' queries that need to be logged, and their duration tra

Re: [ADMIN] PGDG RPMS and integer-datetimes support

2005-05-14 Thread S Murthy Kambhampaty
--- Devrim GUNDUZ <[EMAIL PROTECTED]> wrote: > Could you please tell us why integer datetimes > should be enabled in our > RPMs by default? > > We are not sure that many people need it, also it's > easy for someone to > add this support using the SRPMs provided. > "Consistent precision through

Re: [ADMIN] Permissions not removed when group dropped

2005-05-14 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > No, that's why I haven't mentioned it :-) I know I can't do anything > about objects in other databases. But I have wondered if we could > implement CASCADE behavior for an object whose dependencies are only > local to the current database (where CASCA