I have been trying to set up "hot standby" replication, but have run
into problems, and hope someone here can help.
I have configured an ssh tunnel from a computer that is not on a public
IP, and was unable to figure out how to run pg_basebackup from that
server to backup the data from the mai
Hi,
When I have been passing through "Understanding explain" manual (
http://www.dalibo.org/_media/understanding_explain.pdf) I've faced some
strange situation when table with size of 65MB completely placed in cache
with shared_buffers=320MB and it doesn't with shared_buffers <= 256MB.
Actually be
Over the last several months, I've seen a lot of grumbling about how
zone_reclaim_mode eats babies, kicks puppies, and basically how you should just
turn it off and live happily ever after. I thought I should add a
counterexample, because that advice has not proven very good for us.
Some facts
Formatted query attached in addition to placing it inline. The commentary
is inline with the query. Basically I've already solved this problem but
was wondering if someone has a different perspective; or simply
observations.
TIA,
David J.
/*
For a given id there are multiple linked values of
Hi and thanks for the answer
2015-09-04 11:45 GMT+02:00 Albe Laurenz :
> Etienne Champetier wrote:
> > We are planning to add a C extension (
> https://github.com/petropavel13/pg_rrule) to our shared
> > postgresql cluster, and wondering what are the risk? (looking for the
> worst case scenario h
On 9/3/15 11:36 PM, Craig Ringer wrote:
Please show your connection strings, and the contents of bdr.bdr_nodes
and bdr.bdr_connections.
On 3 September 2015 at 05:00, Ray Stell wrote:
This doc specifies to initdb with the admin user "postgres,"
http://bdr-project.org/docs/stable/quickstart-inst
Etienne Champetier wrote:
> We are planning to add a C extension
> (https://github.com/petropavel13/pg_rrule) to our shared
> postgresql cluster, and wondering what are the risk? (looking for the worst
> case scenario here)
>
> If there is a SIGSEGV, SIGBUS, SIGABRT ..., is the whole server stop
On 2015-08-31 16:05, ma...@kset.org wrote:
On 2015-08-31 14:38, Martín Marqués wrote:
El 31/08/15 a las 03:29, ma...@kset.org escribió:
Last week we had some problems on the master server which caused a
failover on the slave (the master was completely unresponsive due to
reasons still unknown).
If I drop the FINANCIAL_INSTIT table, create it again, and run the insert
commands, it now contains 9 rows as expected.
- Mail original -
De: phi...@free.fr
À: pgsql-general@postgresql.org
Envoyé: Vendredi 4 Septembre 2015 09:45:36
Objet: [GENERAL] Duplicate rows inserted in PGSQL 9.4 f
Hello,
I am using PGSQL 9.4 for Windows on Windows 7.
when I insert 9 rows in a table called FINANCIAL_INSTIT, 24 rows end up being
created!
Furthermore, accented characters encoded in UTF-8 in the original SQL file,
such as
é, end up as "é".
Any help would be much appreciated.
Philippe
10 matches
Mail list logo
