On Thu, Nov 7, 2013 at 7:24 PM, Tom Lane wrote:
> I wrote:
> > It looks like the problem is we're building a MergeAppend plan and not
> > getting the targetlist for the MergeAppend node right.
>
> Found it --- simple oversight in building optimized min/max plans.
> If you need a patch now, see
>
Hi,
@Francisco - Yeah, the file is around 600 Mb currently, uncompressed.
You're right, our internet connection is going to be the limiting factor.
Essentially, the PostgreSQL server is in a datacentre, the server we're
dumping to is in the office.
Running a script on the PostgreSQL server in t
would any of this help make it more clear on what I seem to be doing wrong?
pgbouncer=# show config;
key| value
| changeable
---+-+
job_name
Hello,
we are trying pg_upgrade on an old test instance (9.1 -> 9.3)
the check fails for a library that we don't mange to locate in the old system.
(we suspect it to come from a very old try to implement a custom FTS parser).
So my question: can we find out where the pg_ugrade checker did find th
has it got to do with the DNS I have checked on the admin consol and a
recieved this:
pgbouncer=# show dns_hosts;
hostname | ttl | addrs
--+-+---
(0 rows)
pgbouncer=# show dns_zones;
zonename | serial | count
--++---
(0 rows)
Not to sure if this helps.
-
has it got to do with the DNS I have checked on the admin consol and a
recieved this:
pgbouncer=# show dns_hosts;
hostname | ttl | addrs
--+-+---
(0 rows)
pgbouncer=# show dns_zones;
zonename | serial | count
--++---
(0 rows)
Not to sure if this he
> Hello,
> we are trying pg_upgrade on an old test instance (9.1 -> 9.3)
>
> the check fails for a library that we don't mange to locate in the old
> system.
> (we suspect it to come from a very old try to implement a custom FTS
> parser).
>
> So my question: can we find out where the pg_ugrade c
Hi Victor:
> You're right, our internet connection is going to be the limiting factor.
...
Good to know this. Then you have 1 restriction, your bandwidth...
> Essentially, the PostgreSQL server is in a datacentre, the server we're
> dumping to is in the office.
> Running a script on the Post
Does any of this help this is the config file i get when I type in show
config in the pgbouncer admin console:
pgbouncer=# show config;
key| value
| changeable
---+
Ok now I seem to have gotten it working by changing the store port numbers to
pgbouncer because its using port no 5432 and postgres is now using 6432.
So now it seems to be giving me the server details that is being used when
the map gets run:
pgbouncer=# show servers;
type | user | database
On 11/06/2013 12:56 AM, Massimo Ortensi wrote:
Hi everybody. I downloaded and tested 9.3 beta 1 back in june and used
for a while.
Today I upgraded to 9.3.1 but just discovered that database cannot be
directly used, so I need to switch back to the beta version in order to
dump the data.
Is there
On 11/08/2013 05:41 AM, si24 wrote:
Ok now I seem to have gotten it working by changing the store port numbers to
pgbouncer because its using port no 5432 and postgres is now using 6432.
So now it seems to be giving me the server details that is being used when
the map gets run:
pgbouncer=# sho
Hi all,
I¹m having difficulty using variable interpolation within psql, where that
variable is within a table name
Like so..
=# set MM 201310
=# select :MM;
?column?
--
201309
(1 row)
=# alter table my_table rename to my_table_:MM_raw;
ERROR: syntax error at or near
maybe a stupid answer,
but why not use another language (plpgsql? python?).
Is it because of transaction issue?
Sorry for not being more helpfull.
Cheers,
Rémi-C
2013/11/8 Tim Kane
> Hi all,
>
> I’m having difficulty using variable interpolation within psql, where that
> variable is within a ta
thanks andy!
a little off-topic, but about database reorganization - is it recommended
to group all sequences and domains under the public schema? or is a
sequence tied to one table and is better in its separate schema?
what about replication options for x64 systems since slony is not an option?
Etienne Dube writes:
> This query yields unexpected results (tested under 9.2.4):
> SELECT
> s.car_id,
> s.color_id AS subquery_color_id,
> co.color_id AS join_color_id,
> co.color_name
> FROM
> (
> SELECT
> ca.car_id,
> (
>
On 11/08/2013 08:08 AM, Tim Kane wrote:
Hi all,
I’m having difficulty using variable interpolation within psql, where
that variable is within a table name…
Like so..
=# set MM 201310
=# select :MM;
?column?
--
201309
(1 row)
=# alter table my_table rename to my_table_:
On 08/11/2013 16:47, "Adrian Klaver" wrote:
>>
>test=> \set tbl_name 'my_table_':MM'_raw';
>
>test=> alter table my_table rename to :tbl_name;
>ALTER TABLE
>
>test=> \d my_table_201310_raw
>Table "public.my_table_201310_raw"
> Column | Type | Modifiers
>+-+---
>
On 11/8/2013 9:57 AM, Bosco Rama wrote:
On 11/08/13 09:30, Tim Kane wrote:
>
>Remi, to answer your question - this is being called as part of a shell
>script.
In that case your options expand greatly...
I'd still suggest perl for this, especially if it is ever going to get
even a little bit
On 11/08/13 09:30, Tim Kane wrote:
>
> Remi, to answer your question - this is being called as part of a shell
> script.
In that case your options expand greatly...
For example:
tbl_name="MM"
psql -c "alter table my_table rename to my_table_${tbl_name}_raw;"
or for more complex stuff
my response hasn't shown up on
http://postgresql.1045698.n5.nabble.com/upgrading-to-9-3-td5777291.html so
trying again. sorry if both show up.
anyway, on database reorganization - is it recommended to group all
sequences and domains under one public schema? or is a sequence tied to a
table as its
On 11/8/2013 11:44 AM, zach cruise wrote:
my response hasn't shown up on
http://postgresql.1045698.n5.nabble.com/upgrading-to-9-3-td5777291.html so
trying again. sorry if both show up.
anyway, on database reorganization - is it recommended to group all
sequences and domains under one public s
On Fri, Nov 8, 2013 at 12:09 PM, John R Pierce wrote:
> On 11/8/2013 11:44 AM, zach cruise wrote:
>> anyway, on database reorganization - is it recommended to group all
>> sequences and domains under one public schema? or is a sequence tied to a
>> table as its counter?
>
> I would keep sequences
Andreas Ulbrich writes:
> In the documentation I can't find, that / is not possible as an unary
> operator.
> Are there any restrictions.
Yeah, if you look in the bison grammar you'll find out that the operators
with special precedence are hard-wired as to which syntaxes are allowed:
+ -
Hi,
My postgres sessions, after being idle for 5 --6 hrs, crash on their own.
Sometimes with error messages sometimes without. The message I get appended
below. I was looking for suggestion to narrow down as to what could have
caused this problem. System log doesn't show anything.
Thanks.
Sandee
Sandeep Gupta writes:
> My postgres sessions, after being idle for 5 --6 hrs, crash on their own.
> Sometimes with error messages sometimes without. The message I get appended
> below. I was looking for suggestion to narrow down as to what could have
> caused this problem. System log doesn't show
Hi,
When I search for material on PostgreSQL, once in a while I see reasonably
old, but very good content in file such as
http://www.postgresql.org/files/developer/transactions.pdf
How can I browse to a top level folder (
http://www.postgresql.org/files/developer) and see what else is available ?
27 matches
Mail list logo
