On Thu, Nov 7, 2013 at 7:24 PM, Tom Lane t...@sss.pgh.pa.us 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
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
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
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
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
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
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=#
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 tim.k...@gmail.com
Hi all,
I’m having difficulty using variable interpolation within psql, where that
variable
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 etd...@gmail.com 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
On 08/11/2013 16:47, Adrian Klaver adrian.kla...@gmail.com 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
On Fri, Nov 8, 2013 at 12:09 PM, John R Pierce pie...@hogranch.com 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
Andreas Ulbrich andreas.ulbr...@matheversum.de 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
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.
Sandeep Gupta gupta.sand...@gmail.com 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.
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
