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
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
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
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 packages
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 *
-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
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
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 distros:
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
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]
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 compiled with gssapi
On Mon, Mar 26, 2012 at 4:32 AM, and andreaesposit...@gmail.com 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
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
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
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 info
Gauthier, Dave dave.gauth...@intel.com 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
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
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
david.sahag...@emc.com 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,
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
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
On 26 March 2012 11:32, and andreaesposit...@gmail.com 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
On 26 March 2012 16:30, Gregg Jaskiewicz gryz...@gmail.com 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; $$
On 26 March 2012 16:41, Thom Brown t...@linux.com 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
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:
Gregg Jaskiewicz gryz...@gmail.com writes:
On 26 March 2012 16:41, Thom Brown t...@linux.com 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
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
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
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
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
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.
--
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
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
On Tue, Mar 27, 2012 at 1:00 PM, David Boreham david_l...@boreham.org 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
* Tim Uckun (timuc...@gmail.com) wrote:
On Tue, Mar 27, 2012 at 1:00 PM, David Boreham david_l...@boreham.org 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
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 it
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
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:
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
On Mon, Mar 26, 2012 at 6:22 PM, leaf_yxj leaf_...@163.com 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
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
41 matches
Mail list logo