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 INTEG
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 t
-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" wrote:
> Oh, BTW,
On Mon, Oct 25, 2010 at 1:12 PM, Michael Gould
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 Linux servers
> running Postgres.
It's
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 wi
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:
**
Pr
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 6
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 tha
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 values
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 fai
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 some
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:
https://www.postgresqlconferenc
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
resto
"Latrous, Youssef" 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.
regards, tom lane
--
Sent v
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 sl
On Mon, Oct 25, 2010 at 1:58 PM, Fredric Fredricson
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 inventions.
>
This is nothing t
18 matches
Mail list logo
