Re: [ADMIN] disable trigger all

On Thu, Jul 16, 2009 at 11:21 AM, John Liu wrote: > Will disable trigger all on table X also disable all the rules on this table > A? No. > Since all constraints in postgresql are implemented by triggers, will > disable trigger also disable foreign key constraint on table X? Yes. -- Sent via p

Re: [ADMIN] One data dir and two servers

On Fri, Jul 17, 2009 at 2:30 PM, Nikolai ZHUBR wrote: > Hello people, > > I'd like to be able to run one of TWO independently installed server > instances on the same single data cluster. Actually, there are even > 2 separate OS instances for that, though they are mostly identical and > they share

[ADMIN] One data dir and two servers

Hello people, I'd like to be able to run one of TWO independently installed server instances on the same single data cluster. Actually, there are even 2 separate OS instances for that, though they are mostly identical and they share the same harddisk. Server instances are also identical versions.

[ADMIN] pgsnmpd

Hello, Is pgsnmpd omitted from -contrib for 8.4? If yes, does the availabe version at [1] work with 8.4? [2] tells that a PGSQL-MIB will be added, did this happen or the project got stuck and nobody cares? :) I'd like to extract information from a running PostgreSQL over snmp and this would just s

Re: [ADMIN] migrating from 8.1.x to 8.4

On Fri, 2009-07-17 at 11:53 -0700, Anj Adu wrote: > We are considering a switch from 8.1.x to 8.4 for some of our > databases.Is there a document that highlights the differences > between these 2 versions. We are not migrating the db but using the > same schema on the newer version. http://www

[ADMIN] migrating from 8.1.x to 8.4

We are considering a switch from 8.1.x to 8.4 for some of our databases.Is there a document that highlights the differences between these 2 versions. We are not migrating the db but using the same schema on the newer version. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) T

Re: [ADMIN] Tests with switch of WAL segment files.

"J. Carlos Muro" wrote: >> Hi! I am trying to better understand when switch of WAL files takes >> place. I believe that it happens when the file is full, when pg_xlog_switch is run (if there has been anything written to the current WAL file). I think, at least in some version, a switch is als

[ADMIN] 8.4 contrib binaries

It appears that with version 8.4 the contrib binaries are no longer available. I need the UUID library so that I can call functions to generate a UUID. I need these for the Windows environment. Is there any reason why the contrib modules for the most part have been left out of the installs by En

Re: [ADMIN] Enhancement - code completion when typing set search_path

Campbell, Lance schrieb: I use postgres 8.1.X. Is there a way to add code completion when entering: set search_path = xyz I love the code completion for SQL. It would be really nice to have it for the "set search_path". me too ;-) you should send this request to the hackers list ... may

Re: [ADMIN] Tests with switch of WAL segment files.

I realized something else, that only happened once. I recreated the cluster. If I execute "select pg_switch_xlog();" once, then segment file gets almost immediately switched (a new file is created) even though I don't insert new data. If I waite some thime and execute "select pg_switch_xlog();" the

Re: [ADMIN] PostgreSQL using 100% CPU

Hi, All! I migrate from Win/MSSQL to FC/PostgreSQL. After month of work on fedora > postgresql server, accounters can't calculate one form. I detect, that > postgres process use a 100% of CPU. > How solve this problem? Thanks a lot. > 2 CPU, 4 Gb RAM, 2x250 Gb (229 Gb free), autovacuum is on. >