[GENERAL] compilation info without pg_config

2012-03-26 Thread Maximilian Tyrtania
Hi there, i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been compiled with gssapi support. The PG OpenSuse package seems to not ship pg_config for some reason. Is there another way to determine that? Maximilian Tyrtania http://www.contactking.de -- Sent via pgsql-g

[GENERAL] Values inside rolvaliduntil of pg_authid

2012-03-26 Thread Frank Lanitz
Hi folks, I'm currently doing some checks for users. During this I've found inside pg_authid.rolvaliduntil a couple of values I wasn't able to figure out via documentation, whether they are valid Maybe you can help me out helping whether these are valid dates and what is postgres interpreting

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread John R Pierce
On 03/26/12 2:22 AM, Maximilian Tyrtania wrote: i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been compiled with gssapi support. The PG OpenSuse package seems to not ship pg_config for some reason. the redhat packages put pg_config in /usr/pgsql-x.y/bin (and its part

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Maximilian Tyrtania
Am 26.03.2012 um 11:34 schrieb John R Pierce: > On 03/26/12 2:22 AM, Maximilian Tyrtania wrote: >> i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been >> compiled with gssapi support. The PG OpenSuse package seems to not ship >> pg_config for some reason. > > the redhat

Re: [GENERAL] can these queries be combined into one?

2012-03-26 Thread Tom Molesworth
Hi, On 25/03/12 08:16, haman...@t-online.de wrote: I am currently doing something like select ordercode, descr, codes into temp table x from products where ... Here codes is a bit-mapped field update x set codes = codes | 512 from othertable t where ordercode = t.ordercode and select * fr

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > i'd like to figure out if my pg server (9.0.2) running on OpenSuse > has been compiled with gssapi support. The PG OpenSuse package > seems to not ship pg_config for some reason. That's a known bug (IMO) with most distros: pg_config is put

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Adrian Klaver
On 03/26/2012 03:01 AM, Maximilian Tyrtania wrote: Am 26.03.2012 um 11:34 schrieb John R Pierce: On 03/26/12 2:22 AM, Maximilian Tyrtania wrote: i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been compiled with gssapi support. The PG OpenSuse package seems to not ship

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Devrim GÜNDÜZ
On Mon, 2012-03-26 at 13:05 +, Greg Sabino Mullane wrote: > > i'd like to figure out if my pg server (9.0.2) running on OpenSuse > > has been compiled with gssapi support. The PG OpenSuse package > > seems to not ship pg_config for some reason. > > That's a known bug (IMO) with most distro

[GENERAL] loading a function from a file

2012-03-26 Thread and
Hi all, I would like to know how to load a user defined function from a file written in pl/pgsql. I have read it on logging psql -h host database < create_some_func.sql but then i am forced to redo the login.Is there another way to do it? -- Sent via pgsql-general mailing list (pgsql-general@po

[GENERAL] PostgreSQL crashed server

2012-03-26 Thread Martín Marqués
Saturday our DB development server crashed (no big deal, it's not the production server), and checking out the logs in /var/log/messages, I get this: Mar 24 02:34:48 bugs kernel: [297840.580276] postgresD c10201fe 0 1471 1463 0x Mar 24 02:34:48 bugs kernel: [297840.580281]

Re: [GENERAL] compilation info without pg_config

2012-03-26 Thread Maximilian Tyrtania
Am 26.03.2012 um 15:09 schrieb Adrian Klaver: > On 03/26/2012 03:01 AM, Maximilian Tyrtania wrote: >> Am 26.03.2012 um 11:34 schrieb John R Pierce: >> >>> On 03/26/12 2:22 AM, Maximilian Tyrtania wrote: i'd like to figure out if my pg server (9.0.2) running on OpenSuse has been compile

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Merlin Moncure
On Mon, Mar 26, 2012 at 4:32 AM, and wrote: > Hi all, > I would like to know how to load a user defined function from a file > written in pl/pgsql. > > I have read it on logging > psql -h host database <  create_some_func.sql > but then i am forced to redo the login.Is there another way to do it?

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Andy Colson
On 3/26/2012 4:32 AM, and wrote: Hi all, I would like to know how to load a user defined function from a file written in pl/pgsql. I have read it on logging psql -h host database< create_some_func.sql but then i am forced to redo the login.Is there another way to do it? You can put default

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Adrian Klaver
On 03/26/2012 02:32 AM, and wrote: Hi all, I would like to know how to load a user defined function from a file written in pl/pgsql. I have read it on logging psql -h host database< create_some_func.sql but then i am forced to redo the login.Is there another way to do it? Not sure what you a

[GENERAL] "OLD used in query that is not in a rule"

2012-03-26 Thread Gauthier, Dave
I get... "OLD used in query that is not in a rule" when trying to ref, for example, OLD.tblcol1, from inside a stored procedure. Is this saying you cannot use OLD.* (or NEW.* I suppose) unless it's from within a trigger function (returns type "trigger")? If so, is there some way to tap this in

Re: [GENERAL] "OLD used in query that is not in a rule"

2012-03-26 Thread Tom Lane
"Gauthier, Dave" writes: > I get... "OLD used in query that is not in a rule" when trying to ref, for > example, OLD.tblcol1, from inside a stored procedure. Is this saying you > cannot use OLD.* (or NEW.* I suppose) unless it's from within a trigger > function (returns type "trigger")? Certa

Re: [GENERAL] "OLD used in query that is not in a rule"

2012-03-26 Thread Gauthier, Dave
OK, and understood. And yes, I thought it was a global. Thanks Tom. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, March 26, 2012 10:52 AM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] "OLD used in query that is not in a rule"

Re: [GENERAL] Change the default [tgenabled] for new "internal" triggers ?

2012-03-26 Thread david.sahagian
Scenario: (not slony, it is home-grown replication) A change on the Primary db is Captured and then Propagated to the Secondary db. Then the change is Applied to the Secondary db, with [session_replication_role] = 'replica'. I agree that I don't want my "user triggers" to fire as part of the App

Re: [GENERAL] Change the default [tgenabled] for new "internal" triggers ?

2012-03-26 Thread Tom Lane
writes: > But my email was about the "internally generated constraint triggers" > which implement checking for Foreign Key Constraint violations. Yeah ... > It is that checking that I want to be done on the Secondary. > Should I not want such checking to be done ? What for, when it was already

Re: [GENERAL] can these queries be combined into one?

2012-03-26 Thread Rainer Pruy
Solution heavily depends on the relation of products and othertable. If ordercode at most has a single match with ordercode from othertable, then a simple left join and a coalesce() or CASE in the select list will do ( SELECT p.ordercode, p.descr, CASE WHEN t.codes is NULL THEN p.ordercode ELSE t

[GENERAL] language name case sensitivity, also known as plpgsql <> 'PLpgSQL'

2012-03-26 Thread Gregg Jaskiewicz
Folks, I'm testing some code on 9.2dev (trunk), and I've noticed that postgresql seems to be fussy about language case when creating a function. So for instance: create function foo() returns int AS $$ BEGIN return 1; END; $$ LANGUAGE 'PLpgSQL'; Will be fine on 8.3 (my current version used in prod

Re: [GENERAL] loading a function from a file

2012-03-26 Thread Alban Hertroys
On 26 March 2012 11:32, and wrote: > I have read it on logging > psql -h host database <  create_some_func.sql > but then i am forced to redo the login.Is there another way to do it? If you're working on the database server, then you can skip the "-h host" bit and use a socket. That does require

Re: [GENERAL] language name case sensitivity, also known as plpgsql <> 'PLpgSQL'

2012-03-26 Thread Thom Brown
On 26 March 2012 16:30, Gregg Jaskiewicz wrote: > Folks, > I'm testing some code on 9.2dev (trunk), and I've noticed that > postgresql seems to be fussy about language case when creating a > function. > So for instance: > create function foo() returns int AS $$ BEGIN return 1; END; $$ > LANGUAGE '

Re: [GENERAL] language name case sensitivity, also known as plpgsql <> 'PLpgSQL'

2012-03-26 Thread Gregg Jaskiewicz
On 26 March 2012 16:41, Thom Brown wrote: > > Probably something to do with this: > http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67dc4eed42186ba6a2456578899bfd38d003201a Sounds very plausible. Would you call it a regression ? I would say so, but not sure what would be an arg

Re: [GENERAL] Quite a fast lockless vacuum full implemenation

2012-03-26 Thread Witt83
Hi there. So I'm only an amateur in all this programming stuff. But to my surprise i understand the problem you've described there. Guess my knowledge is getting better. http://flvtoaviconverter.org/ flv to avi -- View this message in context: http://postgresql.1045698.n5.nabble.com/Quite-a-fas

Re: [GENERAL] language name case sensitivity, also known as plpgsql <> 'PLpgSQL'

2012-03-26 Thread Tom Lane
Gregg Jaskiewicz writes: > On 26 March 2012 16:41, Thom Brown wrote: >> Probably something to do with this: >> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67dc4eed42186ba6a2456578899bfd38d003201a > Would you call it a regression ? It's an intentional change to make handlin

[GENERAL] pgstat wait timeout

2012-03-26 Thread Norberto Dellê
Hello One of our production servers log files is being flooded with the message: 2012-03-26 00:00:11 BRT AVISO: pgstat wait timeout 2012-03-26 00:00:19 BRT AVISO: pgstat wait timeout 2012-03-26 00:00:31 BRT AVISO: pgstat wait timeout 2012-03-26 00:00:39 BRT AVISO: pgstat wait timeout 2012-03-

[GENERAL] Desperately need a magical PG monitoring tool

2012-03-26 Thread Andreas
Hi, is there a tool for monitoring PG servers? Something that checks if a master and a hot-standby is still running flawlessly. I'd be nice if one could generously overlook some errors like wrong passwords. The standby should be watched if it keeps in sync with the master. I have a cron j

[GENERAL] DBT-3 workload running error: tmp_query.sql is missing

2012-03-26 Thread Yangyang
Hi, I have a problem while running DBT-3 workload in PostgreSQL. DBT-3 version is dbt3-v1.5 and PostgreSQL is postgresql-8.0.26. The error is in power_query.result and it says: /home/pgsql/src/dbt3-v1.5/scripts/output/1/run/tmp_query.sql: No such file or directory The tmp_query.sql is not generate

Re: [GENERAL] Desperately need a magical PG monitoring tool

2012-03-26 Thread Richard Huxton
On 26/03/12 19:58, Andreas wrote: Hi, is there a tool for monitoring PG servers? How do you watch that all runs well ? There are a number of tools. You might want to google around: - nagios - monit - munin There are plenty of others Nagios is aimed at multi-server service monitoring (and a

[GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread Tim Uckun
Is there a way to backup a database or a cluster though a database connection? I mean I want to write some code that connects to the database remotely and then issues a backup command like it would issue any other SQL command. I realize the backups would need to reside on the database server. --

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread John R Pierce
On 03/26/12 4:05 PM, Tim Uckun wrote: Is there a way to backup a database or a cluster though a database connection? I mean I want to write some code that connects to the database remotely and then issues a backup command like it would issue any other SQL command. I realize the backups would nee

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread David Boreham
fwiw we run db_dump locally, compress the resulting file and scp or rsync it to the remote server. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread Tim Uckun
On Tue, Mar 27, 2012 at 1:00 PM, David Boreham wrote: > fwiw we run db_dump locally, compress the resulting file and scp or rsync it > to the remote server. I wanted to see if I can do that without running pg_dump on the remote server. That would involve connecting to the server via ssh and I wan

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread Stephen Frost
* Tim Uckun (timuc...@gmail.com) wrote: > On Tue, Mar 27, 2012 at 1:00 PM, David Boreham wrote: > > fwiw we run db_dump locally, compress the resulting file and scp or rsync it > > to the remote server. > > I wanted to see if I can do that without running pg_dump on the remote > server. That woul

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread Bret Stern
On Mon, 2012-03-26 at 16:16 -0700, John R Pierce wrote: > On 03/26/12 4:05 PM, Tim Uckun wrote: > > Is there a way to backup a database or a cluster though a database > > connection? I mean I want to write some code that connects to the > > database remotely and then issues a backup command like i

Re: [GENERAL] Backing up through a database connection (not pg_dump)

2012-03-26 Thread Tim Uckun
> > We're also using libpq to trigger backups using NOTIFY from a client > app. Do you have an example of how this is done? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] postgresql commit.

2012-03-26 Thread leaf_yxj
Oracle database, the other user can't see the uncommited data, for postgresql 8.2 , it looks like once you issue insert , the other user will automatically see new record. was it wrong? I am pretty new to postgresql? Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.co

[GENERAL] Error trying to set up streaming replication

2012-03-26 Thread Nick
I followed the instructions from http://packetcloud.net/2010/12/09/setting-up-streaming-replication-in-postgresql-9-0/ When I start the standby I get this... LOG: database system was shut down in recovery at 2012-03-26 17:36:32 PDT LOG: entering standby mode cp: cannot stat `/var/lib/postgresql

Re: [GENERAL] postgresql commit.

2012-03-26 Thread Chris Travers
On Mon, Mar 26, 2012 at 6:22 PM, leaf_yxj wrote: > Oracle database, the other user can't see the uncommited data,  for > postgresql 8.2 , it looks like once you issue insert , the other user will > automatically see new record. was it wrong? I am pretty new to postgresql? Most likely you are comm

Re: [GENERAL] postgresql commit.

2012-03-26 Thread Andrew Sullivan
On Mon, Mar 26, 2012 at 06:22:20PM -0700, leaf_yxj wrote: > Oracle database, the other user can't see the uncommited data, for > postgresql 8.2 , it looks like once you issue insert , the other user will > automatically see new record. was it wrong? I am pretty new to postgresql? Did you actually