On 24 Oct 2010, at 15:41, Reuven M. Lerner wrote:
I've managed to improve things quite a bit by using cursors, but I've been
stumped in trying to find a replacement for the COUNT(*). I wrote a function
that works great on 9.0:
CREATE OR REPLACE FUNCTION count_the_rows() RETURNS INTEGER
On 10/23/2010 02:01 PM, zhong ming wu wrote:
Hello
I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync
For some reason it failed recently with return codes 32512 and I
couldn't find this num. as a valid rsync exit code
During the time that the error was going on I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 25 Oct 2010 09:49:02 +0200, Fredric Fredricson wrote abour Re:
[GENERAL] What is return code for WAL send command:
On 10/23/2010 02:01 PM, zhong ming wu wrote:
[snip]
For some reason it failed recently with return codes 32512 and I
Is there a patch being worked on which will allow this contrib module to
work properly under Windows 64 bit machines using the 64 bit Postgres
server? We need to be able to support both Windows and Linux servers
running Postgres.
Best Regards
Michael Gould
Mike Christensen m...@kitchenpc.com
On Mon, Oct 25, 2010 at 1:12 PM, Michael Gould
mgo...@intermodalsoftwaresolutions.net wrote:
Is there a patch being worked on which will allow this contrib module to
work properly under Windows 64 bit machines using the 64 bit Postgres
server? We need to be able to support both Windows and
Please leave the ML in the reply-list, so that others might benefit from the
answers, comment on the solution, etc etc. ;)
On 25 Oct 2010, at 13:55, AI Rumman wrote:
I am using Postgresql 8.1 and facing the similar problem.
Can you provide the link where I get the information what you did
Hi there,
I'm trying to install the binary packages for Windows from Graphical installer
to my Desktop computer at job using EntrepriseDB Windows 32 binary but
unfortunatly I'm also running into error message:
**
Apologies in advance as I'm compelled to resurrect this topic:
I've posted my latest issue to the novice list
(http://archives.postgresql.org/pgsql-novice/2010-10/msg00137.php)
.. to no avail
And just to re-state the issue - make check doesn't work as it fails
to start the Postmaster (within 60
All,
I have simple query like 'select * from table1 where
column1=-107.689878'. This returns an empty set. But there is data
corresponding to this value of column.
When I looked more into it, it seems like a precision issue. The value
for column1 is -107.689878.
More interesting is
Hello Sairam,
What is the type of the colum?, what version of postgres are you using?
I didn't had any problem retrieving data in both ways... check out the below
=
test=# create temp table test (col1 float);
CREATE TABLE
test=# insert into test
On 10/25/2010 01:19 PM, David W Noon wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 25 Oct 2010 09:49:02 +0200, Fredric Fredricson wrote abour Re:
[GENERAL] What is return code for WAL send command:
On 10/23/2010 02:01 PM, zhong ming wu wrote:
[snip]
For some reason it
Hi!
I'm looking for free replication solution for postgresql running on
win2003/8. Requirements are simple installation and administration (at
least one of them). Goal is getting actual database on backup server to
switch to in case of failure of primary one.
Any advice is welcome :)
Is
I'm pleased to be able to say that the schedule for this year's PGDay
Europe conference in Stuttgart, Germany on the 6th - 8th December 2010
is now available.
We have a bumper crop of talks this year, with 13 sessions in German,
26 in English, 2 keynotes and a key signing party!
We're pleased to
Hello,
As a reminder, PgWest 2010 is only 8 days away. Registrations are coming
in quickly so I suggest you get moving, if you are coming :D
Main site:
https://www.postgresqlconference.org/
Talks:
https://www.postgresqlconference.org/2010/west/talks
Registration:
Hi there,
In one of our systems we've noticed the following (strange?) behavior.
In a Master/Slave configuration, we run wal-mgr to achieve data
replication from the master to the slave node. Both nodes run PostgreSQL
8.4.1 (on Solaris 10). The slave starts in archive mode and initiates a
Latrous, Youssef ylatr...@broadviewnet.com writes:
1) Why one of the segments has a different SYSID (knowing that all WAL
segments are originating from the same node)?
They aren't. Somewhere you've got WAL segments slipping in from a
different database cluster.
Thank you for the reply.
This is an embedded system and is isolated (only the master and slave
nodes are reachable within this setup). Is there any way either the
slave or the master node changes the pg_control content? The Master node
did not restart at all when this happened. Moreover, if the
On Mon, Oct 25, 2010 at 1:58 PM, Fredric Fredricson
fredric.fredric...@bonetmail.com wrote:
On 10/25/2010 01:19 PM, David W Noon wrote:
Ah, yes of course, It was a while ago I played with cron.
man 5 crontab is also a good command to know, or
info crontab if you prefer those modern
18 matches
Mail list logo