On 16 September 2014 03:07, David G Johnston
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 improved readabili
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 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 parameter.
>
>
> I thi
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 the
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 mi
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 reco
On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver
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 then be reflected in t
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 o
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 comman
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 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 database?
That so
2014-09-16 17:39 GMT+02:00 Kevin Grittner :
> Abelard Hoffman 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 expe
On Fri, Sep 12, 2014 at 11:11 PM, Kevin Grittner 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 and b2.lan
On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
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
> id" would ask the remot
On Tue, Sep 16, 2014 at 6:04 PM, Michael Paquier
wrote:
> On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
> 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 val
> 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
On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule wrote:
> 2014-09-16 17:39 GMT+02:00 Kevin Grittner :
>> Abelard Hoffman 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_d
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
wrote:
> On Tue, Sep 16, 2014 at 6:04 PM, Michael Paquier
> wrote:
>> On Tue, Sep 16, 2014 at 8:05 AM, Daniele Varrazzo
>> wrote:
>
>>> I'm learning now something about foreign tables in PG 9.3. I wonder if
>>> there is a clean way to use a sequ
> 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 f
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: worke
On Tue, Sep 16, 2014 at 11:16 AM, Tapan Halani 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 very general question.
On 09/16/2014 10:33 AM, Michael Paquier wrote:
On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule wrote:
2014-09-16 17:39 GMT+02:00 Kevin Grittner :
Abelard Hoffman 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'
Wor
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 d
On Thu, Sep 11, 2014 at 10:25 PM, Craig Ringer 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 NETWORKSERVICE is not cool
On Tue, Sep 16, 2014 at 1:46 PM, Andrzej Pilacik 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 version is missing
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 base
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 us
On Tue, Sep 16, 2014 at 12:39 PM, Adrian Klaver
wrote:
> On 09/16/2014 10:33 AM, Michael Paquier wrote:
>
>> On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule
>> wrote:
>>
>>> 2014-09-16 17:39 GMT+02:00 Kevin Grittner :
>>>
Abelard Hoffman wrote:
> I have a user-defined GUC variable
Marc Van Olmen 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 growing. Until it
On Tue, Sep 16, 2014 at 6:16 PM, Dev Kumkar wrote:
> On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver
> 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" wil
32 matches
Mail list logo
