On 16 September 2014 03:07, David G Johnston david.g.johns...@gmail.com
wrote:
cowwoc wrote
On 15/09/2014 2:02 PM, lup [via PostgreSQL] wrote:
On 09/15/2014 11:49 AM, cowwoc wrote:
I think developers choosing this route (myself included) are willing
to pay the price in exchange for
I have a user-defined GUC variable that was set at the db level. e.g.,
ALTER DATABASE mydb SET myapp.user_id TO '1'
Works fine. When I do a pg_dump, however, that variable isn't included.
Is that expected? It's not really an attribute of the database?
Thanks.
On 14 September 2014 22:01, cowwoc cow...@bbs.darktech.org wrote:
Hi,
I'd like to propose the ability to create temporary schemas.
Unlike temporary tables, this feature would enable developers to create a
temporary schema once and execute CREATE TABLE statements without the
TEMPORARY
Thank you. My solution is based on your suggestion, but instead of creating a
new partition table and inserting into it, I create partitions as I originally
planned, under the existing table, and insert to them. But without deleting.
I use INSERT INTO... SELECT ONLY, without deleting, and so
On 2014-09-15 19:54:42 +0200, p...@mailme.dk wrote:
Is it already possible or would you consider a configuration option that
would only replicate DML but not DDL ?
This should of course be combined with a predictable way of manually
handling DDL errors. Like simply manually adding any
Hi,
On 2014-09-15 19:52:35 +0200, p...@mailme.dk wrote:
Ubuntu 14.04 with compiled BDR 0.7.1
This is a very interesting project for a lot of potential
applications.
Good to hear!
However as in any project there will be a few initial issues.
Definitely.
My question is how do I recover
On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
What OS and what packaging?
For both windows-64-bit and Linux-64-bit.
PostgreSQL version - 9.3.4
I believe the file pgsql/share/postgresql/timezone/Europe/Moscow will
require changes.
As the above changes will
In all the londiste manuals it says about the repair command:Comparing
happens by dumping out table from both sides, sorting them and then
comparing line-by-line. As this is CPU and memory-hungry operation, good
practice is to run the repair command on third machine, to avoid consuming
resources
Good morning,
Through web application, once in a while(totally twice), we got
the following fatal error message. May I know what may cause the
error message please?
org.postgresql.util.PSQLException:
FATAL: terminating connection due to
On 09/16/2014 07:05 AM, Emi Lu wrote:
Good morning,
Through web application, once in a while(totally twice), we got the
following fatal error message. May I know what may cause the error
message please?
org.postgresql.util.PSQLException: FATAL: terminating connection due to
administrator
Hello,
I'm learning now something about foreign tables in PG 9.3. I wonder if
there is a clean way to use a sequence on the remote side, so that an
insert into remote_table values ([data not including id]) returning
id would ask the remote server to generate a new value for id.
As it stands now
Abelard Hoffman abelardhoff...@gmail.com wrote:
I have a user-defined GUC variable that was set at the db level. e.g.,
ALTER DATABASE mydb SET myapp.user_id TO '1'
Works fine. When I do a pg_dump, however, that variable isn't included.
Is that expected? It's not really an attribute of the
2014-09-16 17:39 GMT+02:00 Kevin Grittner kgri...@ymail.com:
Abelard Hoffman abelardhoff...@gmail.com wrote:
I have a user-defined GUC variable that was set at the db level. e.g.,
ALTER DATABASE mydb SET myapp.user_id TO '1'
Works fine. When I do a pg_dump, however, that variable
On Fri, Sep 12, 2014 at 11:11 PM, Kevin Grittner kgri...@ymail.com wrote:
The equivalent of your first query is to take the result sets from
these two queries:
select a1.field1, b1.title, b2.title
from a a1
join b b1 on b1.id = a1.id and b1.lang = 1
left join b b2 on (b2.id = a1.id
On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
daniele.varra...@gmail.com wrote:
I'm learning now something about foreign tables in PG 9.3. I wonder if
there is a clean way to use a sequence on the remote side, so that an
insert into remote_table values ([data not including id]) returning
On Tue, Sep 16, 2014 at 6:04 PM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
daniele.varra...@gmail.com wrote:
I'm learning now something about foreign tables in PG 9.3. I wonder if
there is a clean way to use a sequence on the remote
On 2014-09-15 19:54:42 +0200, p...@mailme.dk wrote:
Is it already possible or would you consider a configuration option that
would only replicate DML but not DDL ?
This should of course be combined with a predictable way of manually
handling DDL errors. Like simply manually adding any
On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
2014-09-16 17:39 GMT+02:00 Kevin Grittner kgri...@ymail.com:
Abelard Hoffman abelardhoff...@gmail.com wrote:
I have a user-defined GUC variable that was set at the db level. e.g.,
ALTER DATABASE mydb SET
Hi,
On 2014-09-16 19:32:38 +0200, p...@mailme.dk wrote:
I am not sure I have a very good case other than the very lousy argument
that I would trust it to be stable much more quickly :-)
Well, we'll get the much more quickly if people report problems ;)
I tried it and it works fine for the
On Tue, Sep 16, 2014 at 10:17 AM, Daniele Varrazzo
daniele.varra...@gmail.com wrote:
On Tue, Sep 16, 2014 at 6:04 PM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
daniele.varra...@gmail.com wrote:
I'm learning now something about foreign
Hi,
On 2014-09-16 19:32:38 +0200, p...@mailme.dk wrote:
I am not sure I have a very good case other than the very lousy argument
that I would trust it to be stable much more quickly :-)
Well, we'll get the much more quickly if people report problems ;)
I tried it and it works fine for the
On 2014-09-16 20:03:21 +0200, p...@mailme.dk wrote:
With DDL disabled then create extension posgis gives a loop on the slave
LOG: starting background worker process bdr
(6059699842869179629,1,16384,): beta: apply
ERROR: relation public.spatial_ref_sys does not exist
LOG: worker process:
On Tue, Sep 16, 2014 at 11:16 AM, Tapan Halani tapanhalani...@gmail.com wrote:
Hello everyone..i am new to PostgreSQL project. I had prior experience with
sql+ , with oracle 11g database server. Kindly help me grasp more about the
project or direct me in the right direction.
Welcome!
That's a
On 09/16/2014 10:33 AM, Michael Paquier wrote:
On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule pavel.steh...@gmail.com wrote:
2014-09-16 17:39 GMT+02:00 Kevin Grittner kgri...@ymail.com:
Abelard Hoffman abelardhoff...@gmail.com wrote:
I have a user-defined GUC variable that was set at the db
I inherited a 8.4.9 500gb database. After doing some analysis on it I
found two issues that I am not sure how to handle.
1. There is an object in pg_class that I can only query by oid or by using
ilike instead of = . That objects also only exists in pg_class, it does
not exist in pg_depend nor
On Thu, Sep 11, 2014 at 10:25 PM, Craig Ringer cr...@2ndquadrant.com wrote:
The PostgreSQL installer now uses the NETWORKSERVICE account on Windows
by default (as of 9.2), instead of creating a postgres account with
username and password. Which is a big improvement to usability.
Using
On Tue, Sep 16, 2014 at 1:46 PM, Andrzej Pilacik cypise...@gmail.com wrote:
I inherited a 8.4.9 500gb database. After doing some analysis on it I found
two issues that I am not sure how to handle.
You should target a dump for an upgrade to a newer version, 8.4 has
been EOL'd recently. And this
That’s a good idea, thanks for sharing Herouth!
From: Herouth Maoz [mailto:hero...@unicell.co.il]
Sent: Tuesday, September 16, 2014 10:22 PM
To: Huang, Suya
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] (Solved) Decreasing performance in table partitioning
Thank you. My solution is
Trying to debug an out of memory error with Postgresql.
Simple:
* Open Connection
* begin transaction
* trying to import about 20GBytes of data (40K rows + rest large image
blob's)
* end transaction
* Close Connection
What I notice is that the python app stays around 200Mbytes of memory
On Tue, Sep 16, 2014 at 12:39 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 09/16/2014 10:33 AM, Michael Paquier wrote:
On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule pavel.steh...@gmail.com
wrote:
2014-09-16 17:39 GMT+02:00 Kevin Grittner kgri...@ymail.com:
Abelard Hoffman
Marc Van Olmen m...@sky4studios.be writes:
[ out of memory while ]
* trying to import about 20GBytes of data (40K rows + rest large image
blob's)
What I notice is that the python app stays around 200Mbytes of memory usage,
but the postgres process on my MacOSX 10.9.5 is growing and
31 matches
Mail list logo