On Sat, May 5, 2012 at 4:19 PM, Stefan Tzeggai tzeg...@wikisquare.dewrote:
Hi
postgresql 9.1 on Ubuntu 10.04
All important information is in the other tablespaces. I would be
totally happy to just loose all relations in that lost tablespace. It's
just indexes. Is there any way to tell PG
On Sunday 06 May 2012 10:29:17 Simon Riggs wrote:
On 4 May 2012 14:55, Vincent de Phily vincent.deph...@mobile-devices.fr
wrote:
It all seems to be working fine, except that when checking the data
(selecting latest primary key and sequence value for all tables) on
master and slave, some
On 7 May 2012 09:01, Vincent de Phily vincent.deph...@mobile-devices.fr wrote:
Would be nice to see it added to the documentation (unless I just didn't find
it ?), as it is quite surprising, and might lead to problems if people expect
to be able to read sequence values from the slave.
If you
On Mon, May 7, 2012 at 10:14 AM, Simon Riggs si...@2ndquadrant.com wrote:
On 7 May 2012 09:01, Vincent de Phily vincent.deph...@mobile-devices.fr
wrote:
Would be nice to see it added to the documentation (unless I just didn't find
it ?), as it is quite surprising, and might lead to problems
On 7 May 2012 09:19, Magnus Hagander mag...@hagander.net wrote:
On Mon, May 7, 2012 at 10:14 AM, Simon Riggs si...@2ndquadrant.com wrote:
On 7 May 2012 09:01, Vincent de Phily vincent.deph...@mobile-devices.fr
wrote:
Would be nice to see it added to the documentation (unless I just didn't
Hi there
I'm trying to use COPY with HEADER option but my header line in file is in
different order than the column order specified in database.
Is the column name order necessary in my file ??
thxs
--
View this message in context:
On 05/07/2012 05:33 AM, MD33 wrote:
Hi there
I'm trying to use COPY with HEADER option but my header line in file is in
different order than the column order specified in database.
Is the column name order necessary in my file ??
From the docs:
Simon Riggs si...@2ndquadrant.com writes:
On 7 May 2012 09:01, Vincent de Phily vincent.deph...@mobile-devices.fr
wrote:
Would be nice to see it added to the documentation (unless I just didn't find
it ?), as it is quite surprising, and might lead to problems if people expect
to be able to
On Mon, May 7, 2012 at 4:01 AM, Vincent de Phily
vincent.deph...@mobile-devices.fr wrote:
On Sunday 06 May 2012 10:29:17 Simon Riggs wrote:
On 4 May 2012 14:55, Vincent de Phily vincent.deph...@mobile-devices.fr
wrote:
Would be nice to see it added to the documentation (unless I just
On Mon, May 7, 2012 at 10:33 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Simon Riggs si...@2ndquadrant.com writes:
On 7 May 2012 09:01, Vincent de Phily vincent.deph...@mobile-devices.fr
wrote:
Would be nice to see it added to the documentation (unless I just didn't
find
it ?), as it is quite
On Mon, May 7, 2012 at 8:52 AM, Michael Nolan htf...@gmail.com wrote:
To cross-pollinate with another thread, if temporary tables (and
insert/delete/update transactions to them) are to be supported on a slave,
will the applications using those temporary tables expect to be able to use
Hi Adrian,
Thanks. I tried to understand how the ODBC driver works. Is that true that
there should be some odbc driver manager and otherwise the ODBC driver can't
work properly. Our ODBC driver is installed on linux 5.7 for the informatic
use. Before we deploy the informatic, we want to test the
On 05/07/2012 07:10 AM, leaf_yxj wrote:
Hi Adrian,
Thanks. I tried to understand how the ODBC driver works. Is that true that
there should be some odbc driver manager and otherwise the ODBC driver can't
work properly. Our ODBC driver is installed on linux 5.7 for the informatic
use. Before we
Hi Magnus,
Thank you for answering my post.
Please see comments on your answer below.
On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma ma.sat...@gmail.com wrote:
Hi There,
While trying to restore a ~700GM binary dump by
Hello,
I have a redhat E5 installation with PostgreSQL 7.4 installation. I have
been tasked with upgrading it to 9.x
I have read that I can install both versions at the same time via YUM and
edit the config file on the new installation to use a different port until
go live time.
Can anyone
At 2012-05-05 01:37:50,Adrian Klaver-3 [via PostgreSQL]
ml-node+s1045698n5686519...@n5.nabble.com wrote:
On 05/04/2012 10:23 AM, leaf_yxj wrote:
I tried test the ODBC driver. I failed and I was told I should install the
odbc driver manager to configure the ODBC driver first, then I can
On Mon, May 7, 2012 at 5:02 PM, Liang Ma ma.sat...@gmail.com wrote:
On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma ma.sat...@gmail.com wrote:
Hi There,
While trying to restore a ~700GM binary dump by command
pg_restore -d
On Mon, May 7, 2012 at 12:54 PM, Magnus Hagander mag...@hagander.net wrote:
On Mon, May 7, 2012 at 5:02 PM, Liang Ma ma.sat...@gmail.com wrote:
On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma ma.sat...@gmail.com wrote:
Hi
Hi, so I have a master-slave set of database servers that are running
postgres 9.0 using streaming replication and I'd like to migrate them
to 9.1. My question is, can 9.0 do streaming replication to 9.1? If
not, what's the best way to upgrade a production database to 9.1 with
no downtime?
I
On Mon, May 7, 2012 at 7:34 PM, Liang Ma ma.sat...@gmail.com wrote:
On Mon, May 7, 2012 at 12:54 PM, Magnus Hagander mag...@hagander.net wrote:
On Mon, May 7, 2012 at 5:02 PM, Liang Ma ma.sat...@gmail.com wrote:
On Fri, May 4, 2012 at 3:58 AM, Magnus Hagander mag...@hagander.net wrote:
On Mon,
On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote:
Hi, so I have a master-slave set of database servers that are running
postgres 9.0 using streaming replication and I'd like to migrate them
to 9.1. My question is, can 9.0 do streaming replication to 9.1?
No.
If
not, what's the best
On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge
guilla...@lelarge.info wrote:
On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote:
Hi, so I have a master-slave set of database servers that are running
postgres 9.0 using streaming replication and I'd like to migrate them
to 9.1. My
On 07/05/2012 20:37, Scott Briggs wrote:
Let me clarify, no downtime meaning I will be failing over from the
current server running 9.0 to a new server running 9.1.
This is one of the scenarios that Slony-I is designed to handle; it may
be worth a look.
Ray.
--
Raymond O'Donnell :: Galway
On mån, 2012-05-07 at 11:08 -0400, Randy Johnson wrote:
Hello,
I have a redhat E5 installation with PostgreSQL 7.4 installation. I have
been tasked with upgrading it to 9.x
I have read that I can install both versions at the same time via YUM and
edit the config file on the new
On Mon, 2012-05-07 at 15:37 -0400, Scott Briggs wrote:
On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge
guilla...@lelarge.info wrote:
On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote:
Hi, so I have a master-slave set of database servers that are running
postgres 9.0 using streaming
1. Is this possible in future releases ?
2. How I can organize interconnect between two clients connected to
different DB ? I need call NOTIFY from pgsql function in one database to
another LISTEN client in another database.
--
Regards
On 05/07/12 1:13 PM, Igor wrote:
1.Is this possible in future releases ?
2. How I can organize interconnectbetween two clients connected to
different DB? I need call NOTIFY from pgsql function in one database
to another LISTEN client in another database.
a listener isn't 'in a database',
On 6.5.2012 16:41, Jov wrote:
I find this work:
SELECT (most_common_vals::varchar::varchar[])[1:3]
FROM pg_stats
WHERE tablename = 'pg_attribute' AND attname = 'attname';
I try cast anyarray to varchar[] directly but failed,do'nt know why pg
not support the cast.
IMHO this is exactly
On 05/07/12 1:40 PM, Igor wrote:
2012/5/7 John R Pierce pie...@hogranch.com mailto:pie...@hogranch.com
On 05/07/12 1:13 PM, Igor wrote:
1.Is this possible in future releases ?
2. How I can organize interconnectbetween two clients
connected to different DB? I need
Hi,
On Windows 2008, sometimes the server fails to start due to an existing
postmaster.pid' file.
I tried rebooting a few times and even force shutting down the server, and
it started up fine.
It seems to be a race-condition of sorts in the code that detects whether
the process with PID
in the
You can specify the column order in the copy statement:
psql -d test -c create table ttt (id serial primary key, name varchar(10),
value int);
echo 10|one | psql -d test -c copy ttt (value,name) from stdin with
delimiter '|';
psql -d test -c select * from ttt;
id | name | value
Dmitry Koterov wrote:
But it's quite strange that SQL+STABLE function does not recalculate
the plan each time it is called.
Because when I use a bunch of SQL+STABLE functions in e.g. a
sub-select of a complex query, I see in
the plan of this complex queries that function calls are expanded.
It
32 matches
Mail list logo