Thanks , it worked
On Wed, Dec 7, 2011 at 12:01 PM, Ben Chobot be...@silentmedia.com wrote:
On Dec 7, 2011, at 8:45 AM, akp geek wrote:
Small Clarification. I have gone through the documentation. I did not
find any thing related to start ans stop replication after the replication
is setup
Small Clarification. I have gone through the documentation. I did not find
any thing related to start ans stop replication after the replication is
setup
1. If I shutdown the primary
2. Shutdown the slave
3. start Primary
4. start slave
Will this automatically catch up the streaming. Can you
On Dec 7, 2011, at 8:45 AM, akp geek wrote:
Small Clarification. I have gone through the documentation. I did not find
any thing related to start ans stop replication after the replication is setup
1. If I shutdown the primary
2. Shutdown the slave
3. start Primary
4. start slave
I accidentally imported lots of data into the postgres database via something
like:
psql -U postgres -q -f super_massive_database_dump.sql
Now, although I've manually dropped all the tables -- and \d+ shows nothing --
there are still various views, functions, etc that must account for a lot of
=?iso-8859-1?Q?Ren=E9_Fournier?= m...@renefournier.com writes:
I accidentally imported lots of data into the postgres database via something
like:
psql -U postgres -q -f super_massive_database_dump.sql
Now, although I've manually dropped all the tables -- and \d+ shows
nothing -- there are
OK, great. Thank. And when I recreate it, should I do so from a template, or
just CREATE DATABASE postgres ?
On 2011-10-26, at 4:10 PM, Tom Lane wrote:
=?iso-8859-1?Q?Ren=E9_Fournier?= m...@renefournier.com writes:
I accidentally imported lots of data into the postgres database via
On 26/10/2011 23:14, René Fournier wrote:
OK, great. Thank. And when I recreate it, should I do so from a template, or
just CREATE DATABASE postgres ?
AIUI, CREATE DATABASE always uses a template - if you don't specify one,
it uses template1 (I think).
Ray.
--
Raymond O'Donnell :: Galway
thx a lot for your help. it worked great :)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4841782.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list
i searched on the net and didnt find this rpm. anyway the output is the
following -
baseurl=http://yum.pgsqlrpms.org/8.4/redhat/rhel-$releasever-$basearch
baseurl=http://yum.pgsqlrpms.org/srpms/8.4/redhat/rhel-$releasever-$basearch
On Wed, 2011-09-21 at 00:59 -0700, MirrorX wrote:
i searched on the net and didnt find this rpm. anyway the output is
the
following -
baseurl=http://yum.pgsqlrpms.org/8.4/redhat/rhel-$releasever-$basearch
Ok, that is the old repo. So, do this as root:
rpm -Uvh
hello all,
i have a centos 5.3 which has postgres 8.4.4 installed from the repos. I
want to upgrade to 8.4.8 but when i try to install the .bin file of 8.4.8
then it's a new installation and when i try to run yum check-update nothing
new is there. any ideas? tnx in advance
--
View this message in
On Tue, Sep 20, 2011 at 8:30 AM, MirrorX mirr...@gmail.com wrote:
hello all,
i have a centos 5.3 which has postgres 8.4.4 installed from the repos. I
want to upgrade to 8.4.8 but when i try to install the .bin file of 8.4.8
then it's a new installation and when i try to run yum check-update
thx for your answer.
do u mean something like that? - yum list | grep *PGDG*rpm
or i shouldn't search in the yum repos?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/upgrade-postgres-to-8-4-8-centos-5-3-tp4822762p4822823.html
Sent from the PostgreSQL - general mailing
If it's in the repo, just do
yum update
and it should get updated.
On Tue, Sep 20, 2011 at 8:49 AM, MirrorX mirr...@gmail.com wrote:
thx for your answer.
do u mean something like that? - yum list | grep *PGDG*rpm
or i shouldn't search in the yum repos?
--
View this message in context:
On Tue, 2011-09-20 at 07:49 -0700, MirrorX wrote:
do u mean something like that? - yum list | grep *PGDG*rpm
or i shouldn't search in the yum repos?
What is the output of:
cat /etc/yum.repos.d/pgdg*|grep baseurl
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB:
Subject: Re: [GENERAL] compile postgres with visual studio 2010
On 20/07/11 18:56, Sofer, Yuval wrote:
I would like to build Postgres from source with the visual studio 2010
compiler
Unless you're willing to use the patch Tom linked to, you should compile
with Visual Studio 2008
Original Message
Subject: Re: [GENERAL] compile postgres with visual studio 2010
From: Sofer, Yuval yuval_so...@bmc.com
To: Craig Ringer cr...@postnewspapers.com.au
Date: 21.07.2011 08:56
Hi
Ok - but how do I install the patch in the link?
I pressed the latest patch link Tom
On 21/07/2011 2:56 PM, Sofer, Yuval wrote:
Hi
Ok - but how do I install the patch in the link?
I pressed the latest patch link Tom Lane gave me (Patch by brar on 2011-07-07
12:37:47 AM: Added documentation, removed pgflex.pl and pgbison.pl. No changes to the
existing code. ), where I saw
Hi
I would like to build Postgres from source with the visual studio 2010 compiler
Is it supported? Is there any document which describes the process of the
implementation?
Thanks,
Yuval Sofer
BMC Software
CTMD Business Unit
DBA Team
972-52-4286-282
On 20/07/2011 11:56, Sofer, Yuval wrote:
Hi
I would like to build Postgres from source with the visual studio 2010
compiler
Is it supported? Is there any document which describes the process of
the implementation?
Yes, it's in the Fine Manual:
Sofer, Yuval yuval_so...@bmc.com writes:
I would like to build Postgres from source with the visual studio 2010
compiler
Is it supported?
Not yet. You could test the pending patch for that:
https://commitfest.postgresql.org/action/patch_view?id=523
regards, tom lane
-CMMI Level 4 Company
We synchronize business, technology and people
From: Greg Smith [mailto:g...@2ndquadrant.com]
Sent: Tuesday, July 19, 2011 11:15 PM
To: MS Rao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Programmer ( Postgres), Milwaukee - offsite-Remote -
onsite
On 07/18/2011 05
On 20/07/11 18:56, Sofer, Yuval wrote:
I would like to build Postgres from source with the visual studio 2010
compiler
Unless you're willing to use the patch Tom linked to, you should compile
with Visual Studio 2008 or with the Microsoft Platform SDK 7.0 (Windows
Vista and .NET 3.5).
More
On 19/07/11 09:58, MS Rao wrote:
*Programmer ( Postgres), Milwaukee -- offsite-Remote - onsite*
We are looking for Postgres skilled programmer with the following skills:
Skills:
Strong in Postgres SQl ,
Set up of database,
Linux
RDBMS expert and strong in design
Possible to work onsite
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Tue, 19 Jul 2011 21:59:19 +1200
From: gavinflo...@archidevsys.co.nz
To: ms@symphonycorp.com
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Programmer ( Postgres), Milwaukee
On Jul 19, 2011, at 9:27 AM, Martin Gainty wrote:
I do'nt believe Rao would discriminate against anyone that speaks the Kings
English.
So, what makes you think they won't hire us Americans?
--
Scott Ribe
scott_r...@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
On 07/18/2011 05:58 PM, MS Rao wrote:
*Programmer ( Postgres), Milwaukee -- offsite-Remote - onsite*
We are looking for Postgres skilled programmer with the following skills:
Job listings are not appropriate for the pgsql-general mailing list.
Please direct them to the pgsql-jobs list in
Programmer ( Postgres), Milwaukee - offsite-Remote - onsite
We are looking for Postgres skilled programmer with the following skills:
Skills:
Strong in Postgres SQl ,
Set up of database,
Linux
RDBMS expert and strong in design
Possible to work onsite /offsite - Remote
Interested candidates
Hi
I programmed an application which uses postgres 9.0. Currently i am writing an
installer for my application and wrote my own GUI to set up postgres settings
and i already install it ofer the original setup.exe with parameters. After
that i want to create user roles and tables with
On 06/28/2011 05:34 AM, Lodron, Gerald wrote:
I have the problem that when i run my batch i always have to let the user type
in the password, thats nasty... I also tried PGPASSWORD but it does not work,
it always prints that it is the wrong password...
I'm not sure if setting PGPASSWORD
On Thu, Jun 16, 2011 at 10:59 PM, Jeff Hamann jeff.d.ham...@gmail.comwrote:
snip
Please don't respond with Why don't you just use the ports collection?
There's reasons - like: 1) need to build from source, 3) it's for a
tutorial, and 3) postgresql90-server isn't building.
Respectfully,
On Thu, Jun 16, 2011 at 1:29 PM, Jeff Hamann jeff.d.ham...@gmail.com wrote:
Please don't respond with Why don't you just use the ports collection?
There's reasons - like: 1) need to build from source, 3) it's for a
tutorial, and 3) postgresql90-server isn't building.
1) ports do build from
[please don't send a post to multiple lists]
Pratheeban Jebasingh Tharmaraj ptharma...@sirahu.com wrote:
I am trying to add column to the table that's hanging.
alter table hr_firms add column_name biginit;
This is the lock I see in the db
relation | 564709 | 586888 | |
I've installed and tested postgresql just fine on FreeBSD 8.2.
I've been trying to get postgresql (the server) to start on bootup using
/etc/rc.conf system.
I'm using the script from the tarball (found in the
contrib/start-scripts/freebsd of postreges tarball)
I can't seem to get it to work
So, what are the gotcha's around manipulating Arrays in stored procs?
It seems reasonable that an array_cat /etc would cause the creation of a new
array, but does mutating an existing array also create a copy?
On Wed, May 25, 2011 at 9:17 PM, bubba postgres
bubba.postg...@gmail.com wrote:
So, what are the gotcha's around manipulating Arrays in stored procs?
It seems reasonable that an array_cat /etc would cause the creation of a new
array, but does mutating an existing array also create a copy?
Hi!
I'm trying to find people who use, administrate or develop PostgreSQL
and live in regions that our community doesn't currently serve.
By doesn't currently serve, I mean that:
* You don't know many other people that use PostgreSQL in your town,
nearby city or country,
* You've never been to
Hello.
When you jail a process, all its attempt to bind to 127.0.0.1 address
will be unsuccessful, and all its attempt to bind to * (all addresses)
will be successful, but in fact it will bind only to jail's IP. So, when
you try to connect to jail's pgsql from jail process will use jail's ip
Hello Postgres Community,
Thank you guys very much for PostgreSQL. To me, its the best database
management system under the sun. I am setting up a new jail configuration
on FreeBSD with sockets and everything enabled. I can ping localhost fine. The
problem is that when I load a script that
On Thu, Mar 31, 2011 at 12:21:33PM -0700, babak badaei wrote:
Hello Postgres Community,
Thank you guys very much for PostgreSQL. To me, its the best database
management system under the sun. I am setting up a new jail configuration
on FreeBSD with sockets and everything enabled. I can ping
Subject: Re: [GENERAL] OSX Postgres PL/Perl Problem with
Finance::Quote/Options
From: vibhor.ku...@enterprisedb.com
Date: Wed, 30 Mar 2011 03:01:29 +0530
CC: pgsql-general@postgresql.org
To: ganbar...@hotmail.com
On Mar 29, 2011, at 9:11 PM, Peter Pan wrote:
I use two Perl
2011/3/30 Peter Pan ganbar...@hotmail.com:
...
Unfortunately none at all, it just fails during the fetch and can't find any
error messages anywhere. As stated, the same module works without problems
in a local separate perl script.
Any ideas?
Skimming the source of Finance::Quote::Yahoo::USA
From: bada...@gmail.com
Date: Wed, 30 Mar 2011 09:33:50 -0600
Subject: Re: [GENERAL] OSX Postgres PL/Perl Problem with
Finance::Quote/Options
To: ganbar...@hotmail.com
CC: pgsql-general@postgresql.org
2011/3/30 Peter Pan ganbar...@hotmail.com:
...
Unfortunately none at all
Hi@all,
I have a weird problem on dev server (using a Mac Mini 2010 Edt., 10.6.7 OSX).
I use two Perl modules Finance::Quote and Finance::QuoteOptions in a stored
PL/Perl procedure which run without problems on a standard LINUX environment
(currently in production on CentOS5). Unfortunately
On Mar 29, 2011, at 9:11 PM, Peter Pan wrote:
I use two Perl modules Finance::Quote and Finance::QuoteOptions in a stored
PL/Perl procedure which run without problems on a standard LINUX environment
(currently in production on CentOS5). Unfortunately on OSX it seems not to be
able to
I've been trying to install postgresql9 on my ubuntu Desktop10 machine and it
seems that it is not supported, as the only version that is available in the
software center is Pgsql 8.4?
Having googled this, i cannot find a straight answer. Is Pgsql9 supported on
Ubuntu10LTS?
Thanks
--
View this
On 25 March 2011 08:42, jcoder leid...@googlemail.com wrote:
I've been trying to install postgresql9 on my ubuntu Desktop10 machine and it
seems that it is not supported, as the only version that is available in the
software center is Pgsql 8.4?
Having googled this, i cannot find a straight
On Thursday, March 24, 2011 4:17:38 pm Andrej wrote:
On 25 March 2011 08:42, jcoder leid...@googlemail.com wrote:
I've been trying to install postgresql9 on my ubuntu Desktop10 machine
and it seems that it is not supported, as the only version that is
available in the software center is
Dear Concern,
I have a machine on which MS SQL Server 2005 is already installed. Now I
want to install PostgreSQL 8.3 along with MS SQL Server.
Can this combination cause any problems to any of the database servers?
Regards,
Shobhit Jain
Disclaimer :- This e-mail and any
I have a machine on which MS SQL Server 2005 is already installed. Now I
want to install PostgreSQL 8.3 along with MS SQL Server.
Can this combination cause any problems to any of the database servers?
You should not run into any problems, both servers run on different
ports (by default)
On Fri, Jan 21, 2011 at 12:28:14PM +0530, Shobhit Jain wrote:
I have a machine on which MS SQL Server 2005 is already installed. Now I
want to install PostgreSQL 8.3 along with MS SQL Server.
Can this combination cause any problems to any of the database servers?
Well, you might find
On Thu, 2010-12-09 at 17:40 +, Paul Taylor wrote:
what
have I got to be careful of.
I think that was in reference to turning fsync off, not work_mem values.
Hi ( sorry for the double posting, thought Id use the wrong email
address but both have been posted anyway). As far as the db is concerned
Im just reading data then writing the data to a lucene search index (which
is outside of the database) , but my labtop is jut a test machine I want
to run
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating large amounts of data , i.e processing
On 12/9/2010 6:25 AM, Paul Taylor wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that
On 12/09/2010 09:59 AM, Andy Colson wrote:
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
sorry: SHMMAX _in_ your OS.
its an OS setting not a PG one.
-Andy
scroll down to the section on OSX
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating large amounts of data , i.e processing
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating large amounts of data , i.e processing
On 09/12/2010 15:12, Reid Thompson wrote:
On 12/09/2010 09:59 AM, Andy Colson wrote:
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
sorry: SHMMAX _in_ your OS.
its an OS setting not a PG one.
-Andy
scroll down
On 12/09/2010 12:36 PM, Paul Taylor wrote:
On 09/12/2010 15:12, Reid Thompson wrote:
On 12/09/2010 09:59 AM, Andy Colson wrote:
On 12/9/2010 8:50 AM, Andy Colson wrote:
On 12/9/2010 6:25 AM, Paul Taylor wrote:
You need to bump up your SHMMAX is your OS.
sorry: SHMMAX _in_ your OS.
its an
On 09/12/2010 15:51, t...@fuzzy.cz wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene
search index from some of the data, and Im trying to improve
performance. The key thing is that I'm only a single user but
manipulating
On Thu, Dec 9, 2010 at 5:25 AM, Paul Taylor ij...@fastmail.fm wrote:
Hi, Im using Postgres 8.3 on a Macbook Pro Labtop.
I using the database with just one db connection to build a lucene search
index from some of the data, and Im trying to improve performance. The key
thing is that I'm only a
I'm creating a data queue on top of postgres and I'm wondering if I've
made
an incorrect assumption about isolation or synchronization or some similar
issue.
Is there a particular reason why you are not using any of the proven
queuing packages (pgq for example)? Because all the issues seem
I'm creating a data queue on top of postgres and I'm wondering if I've made
an incorrect assumption about isolation or synchronization or some similar
issue.
Every item in the queue is given a unique ID from a sequence.
CREATE TABLE data_queue
(
sequence_num BIGINT PRIMARY KEY,
sender_key
Hello all,
I'm creating a data queue on top of postgres and I'm wondering if I've made
an incorrect assumption about isolation or synchronization or some similar
issue.
Every item in the queue is given a unique ID from a sequence.
CREATE TABLE data_queue
(
sequence_num BIGINT PRIMARY KEY,
On 12/07/10 6:04 PM, bubba postgres wrote:
Hello all,
I'm creating a data queue on top of postgres and I'm wondering if I've
made an incorrect assumption about isolation or synchronization or
some similar issue.
Every item in the queue is given a unique ID from a sequence.
CREATE TABLE
On Wed, Dec 1, 2010 at 12:57 AM, Dann Corbit dcor...@connx.com wrote:
The ctid is not permanent. An alternative is to create tables with OID
values.
Creating OIDs gives you zero benefit over having a PK. They would be
roughly equivalent if you added a unique index on the OID column, but
that
On Wed, 2010-12-01 at 09:55 -0500, Vick Khera wrote:
On Wed, Dec 1, 2010 at 12:57 AM, Dann Corbit dcor...@connx.com wrote:
The ctid is not permanent. An alternative is to create tables with OID
values.
Creating OIDs gives you zero benefit over having a PK. They would be
roughly
:* [GENERAL] Does Postgres support bookmarks (tuples ids)?
Dear experts,
I've noticed that commercial databases (e.g. SQLServer) and some open
source databases (e.g. Cubrid) support so called bookmarks.
As far as I understood, a bookmark allows quickly jump to a row for
retrieval
Dear experts,
I've noticed that commercial databases (e.g. SQLServer) and some open source
databases (e.g. Cubrid) support so called bookmarks.
As far as I understood, a bookmark allows quickly jump to a row for
retrieval or modification.
Here is scenario that I'm trying to deal with:
A BI/ETL
...@postgresql.org] On Behalf Of Konstantin Izmailov
Sent: Tuesday, November 30, 2010 9:50 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Does Postgres support bookmarks (tuples ids)?
Dear experts,
I've noticed that commercial databases (e.g. SQLServer) and some open source
databases (e.g. Cubrid
To: pgsql-general@postgresql.org
Subject: [GENERAL] Does Postgres support bookmarks (tuples ids)?
Dear experts,
I've noticed that commercial databases (e.g. SQLServer) and some open source
databases (e.g. Cubrid) support so called bookmarks.
As far as I understood, a bookmark allows quickly jump
Gabriele, Thank you for the link. I downloaded the book and read the chapter.
Very useful information.
Craig,
The storage type is SAN over AFP.
Unfortunately, it has been a week or so since the crash. We were able to
recover lost data from last backup (a few hours old) but next time, I will
On 15/11/10 19:59, anypossibility wrote:
Gabriele,
Thank you for the link. I downloaded the book and read the chapter. Very
useful information.
Craig,
The storage type is SAN over AFP.
I very, very strongly suggest getting your SAN host to export an iSCSI
volume to mount directly on your
I am running postgres postgres version 8.3 on OS X.
The data directory is on network volume.
The network volume was disconnected and server crashed.
Log reported that last know up was 9:30 pm (about 30 min prior to the server
crash.)
My conf Checkpoint_Segments setting = 3 (not sure if this is
On 15/11/10 07:04, anypossibility wrote:
I am running postgres postgres version 8.3 on OS X.
The data directory is on network volume.
What kind of network volume?
An AFP mount? SMB share? NFS? iSCSI?
In general, it's a really bad idea to run PostgreSQL (or any other
database) over file-level
Hi,
In general, it's a really bad idea to run PostgreSQL (or any other
database) over file-level network storage like SMB/AFP/CIFS/NFS.
Block-level network storage like iSCSI is generally OK, depending on the
quality of the drivers in target and initiator.
What Craig says it is true and it
Hi,
I installed latest postgres from sources inside a custom environment of mine.
This environment runs various services, all under a common user/group.
I need to run postgres under the same user/group, witout having to create and
use postgres user.
I could do it, and postgres starts.
But now I
On 03/11/2010 10:29, Gabriele Bulfon wrote:
Hi,
I installed latest postgres from sources inside a custom environment of
mine.
This environment runs various services, all under a common user/group.
I need to run postgres under the same user/group, witout having to
create and use postgres user.
I
Hi Gabriele,
On Wed, 3 Nov 2010 11:29:25 +0100 (CET), Gabriele Bulfon
gbul...@sonicle.com wrote:
I need to run postgres under the same user/group, witout having to
create
and use postgres user.
That's reasonable and perfectly doable with Postgres.
But now I can't seem to connect to the
Hi Gabriele,
I forgot to mention one thing.
That means that PostgreSQL is successfully running. Try and connect to
the
database using a different user by passing the '-U' option to psql or by
setting the PGUSER environment variable.
PostgreSQL creates a role/user inside the cluster with
=-
--
Da: Gabriele Bartolini
A: Gabriele Bartolini
Cc: Gabriele Bulfon
pgsql-general@postgresql.org
Data: 3 novembre 2010 12.26.04 CET
Oggetto: Re: [GENERAL] Running postgres with a different user/group
Hi Gabriele,
I forgot to mention one thing
On 03/11/2010 11:43, Gabriele Bulfon wrote:
Thanx guys, all of your solutions are fine, but I could manage it in a
different manner.
Modified the ident map file to map my special system user to postgres,
so I don't have to
specify the postgres user any more ;)
Good stuff! Glad you got it to
On Fri, Oct 29, 2010 at 4:59 PM, Jeff Davis pg...@j-davis.com wrote:
On Fri, 2010-10-29 at 16:57 -0500, Andy Colson wrote:
begin
insert into logged select * from events where processed = false;
update events set processed = true where processed = false;
commit;
There's a race condition
On Fri, Oct 29, 2010 at 7:59 PM, Jeff Davis pg...@j-davis.com wrote:
On Fri, 2010-10-29 at 16:57 -0500, Andy Colson wrote:
begin
insert into logged select * from events where processed = false;
update events set processed = true where processed = false;
commit;
There's a race condition
On 29 October 2010 03:04, Karl Pickett karl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e.
On 10/29/2010 10:04 AM, Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e. select
* from events where id
On Thursday 28 October 2010 7:04:48 pm Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e. select
*
n Fri, Oct 29, 2010 at 2:53 AM, Peter Geoghegan
peter.geoghega...@gmail.com wrote:
On 29 October 2010 03:04, Karl Pickett karl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary
On Fri, Oct 29, 2010 at 8:58 AM, Adrian Klaver adrian.kla...@gmail.com wrote:
On Thursday 28 October 2010 7:04:48 pm Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to
On Thu, Oct 28, 2010 at 10:04 PM, Karl Pickett karl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so,
On 10/29/2010 9:49 AM, Merlin Moncure wrote:
On Thu, Oct 28, 2010 at 10:04 PM, Karl Pickettkarl.pick...@gmail.com wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental
On 10/29/2010 07:32 AM, Karl Pickett wrote:
On Fri, Oct 29, 2010 at 8:58 AM, Adrian Klaveradrian.kla...@gmail.com wrote:
On Thursday 28 October 2010 7:04:48 pm Karl Pickett wrote:
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients).
On Fri, 2010-10-29 at 16:57 -0500, Andy Colson wrote:
begin
insert into logged select * from events where processed = false;
update events set processed = true where processed = false;
commit;
There's a race condition there. The SELECT in the INSERT statement may
read 5 tuples, then a
Hello Postgres Hackers,
We have a simple 'event log' table that is insert only (by multiple
concurrent clients). It has an integer primary key. We want to do
incremental queries of this table every 5 minutes or so, i.e. select
* from events where id LAST_ID_I_GOT to insert into a separate
Hoping someone can help me with this problem.
I am logging postgres to syslog on a CentOS release 5.4 (Final) (
2.6.18-164.el5 ). When I look for an update statement it appears to
be truncated and missing the whole statement.
Is there a quick way to resolve this? Is it linux or postgres?
Chris Barnes compuguruchrisbar...@hotmail.com writes:
I am logging postgres to syslog on a CentOS release 5.4 (Final) (
2.6.18-164.el5 ). When I look for an update statement it appears to
be truncated and missing the whole statement.
Our code for logging to syslog does split long lines into
On separate lines it is, thanks Tom.
To: compuguruchrisbar...@hotmail.com
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] logging postgres to syslog on centos, truncates the
postgres message.
Date: Thu, 9 Sep 2010 10:39:10 -0400
From: t...@sss.pgh.pa.us
Chris Barnes
Craig Ringer cr...@postnewspapers.com.au wrote in message
news:4c33dc32.7080...@postnewspapers.com.au...
On 06/07/10 17:47, Davor J. wrote:
Thanks Craig.
I still find it a bit awkward that we have to use priv check function-s
because we can't define triggers on or reference to system tables.
301 - 400 of 1052 matches
Mail list logo