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
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 part
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
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
-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 distro
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
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 compile
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?
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 a
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
"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
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 App
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
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
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
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
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 '
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
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
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
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-
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
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
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
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 nee
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 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
* 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
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
>
> 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:
http://postgresql.1045698.n5.nabble.co
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
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
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