Hello experts,
I try to do an update together with a RETURNING clause but without success
(postgresql 9.1 on CentOS 6.2),
the returned data can be multiple rows (not only one row expected like in
src/interfaces/ecpg/test/sql/insupd.pgc):
1:
EXEC SQL DECLARE cur CURSOR FOR UPDATE t set a=0 where
I have Oracle with OS authentication.
And I have installed PostgreSQL and I want to migrate data from Oracle to
PostgreSQL database.
I have performed steps:
CREATE EXTENSION oracle_fdw;
CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '');
GRANT USAGE ON FOREIGN SERVER oradb
On Oct 22, 2012, at 6:57 AM, chinnaobi wrote:
> Hi Laurenz Albe,
>
> I have tested using cygwin rsync in windows 2008 R2, just after restart the
> server.
>
> for 10 GB it took nearly 5 minutes to sync,
> for 50 GB it took nearly 30 minutes, -- too long Though there were no big
> changes.
>
>
Hi
I have Oracle with OS authentication.
And I have installed PostgreSQL and I want to migrate data from Oracle to
PostgreSQL database.
I have performed steps:
CREATE EXTENSION oracle_fdw;
CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver '');
GRANT USAGE ON FOREIGN SERVER or
Hi,
I am quite happy to announce the release of PostgreSQL Magazine in
Chinese, thanks to the tremendous work of the Chinese translators team,
namely Wilson Guam and Scott Siu.
As for the English version you can either read it online, download the
PDF or buy a print copy. Just click on the links
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Tuesday, October 23, 2012 3:31 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need sql to pull data from terribly architected table
Thanks for the answers. But I a
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Richard Broersma
Sent: Tuesday, October 23, 2012 3:24 PM
To: ch...@chriscurvey.com
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need sql to pull data from terribly architecte
Thanks for the answers. But I also have a predicate...
select col1,col2 from foo where col4='c4' and col5 <> 'xxx';
How is that done?
From: Richard Broersma [mailto:richard.broer...@gmail.com]
Sent: Tuesday, October 23, 2012 3:24 PM
To: ch...@chriscurvey.com
Cc: Gauthier, Dave; pgsql-general@po
Heine Ferreira wrote:
> Are there any best practices for avoiding database corruption?
First and foremost, do not turn off fsync or full_page_writes in your
configuration. After that the most common causes for database
corruption I've seen are bad RAM (ECC RAM is a requirement, not an
option for
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Tuesday, October 23, 2012 2:53 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Need sql to pull data from terribly architected table
Here's the deal...
Instead of a
On Tue, Oct 23, 2012 at 2:52 PM, Gauthier, Dave wrote:
> Here's the deal...
>
> ** **
>
> Instead of architecting and loading a table like...
>
> create teble foo (col1 text, col2 text, col3 text, col4 text, col5 text);
>
>
> insert into foo (col1,col2,col3,col4,col5) values
> ('
Here's the deal...
Instead of architecting and loading a table like...
create teble foo (col1 text, col2 text, col3 text, col4 text, col5 text);
insert into foo (col1,col2,col3,col4,col5) values ('c1',null,'c3','c4',null);
They did this instead...
create table foo (property text, value text);
in
On Tue, Oct 23, 2012 at 7:41 AM, Nikolas Everett wrote:
> On Mon, Oct 22, 2012 at 6:17 PM, Alan Hodgson wrote:
>>
>> On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote:
>> > I see that pg_upgrade is an option. Having never used how long should I
>> > expect pg_upgrade to take? Obviou
On Mon, Oct 22, 2012 at 6:17 PM, Alan Hodgson wrote:
> On Monday, October 22, 2012 05:55:07 PM Nikolas Everett wrote:
> > I see that pg_upgrade is an option. Having never used how long should I
> > expect pg_upgrade to take? Obviously we'll measure it in our
> environment,
> > but it'd be nice
Hi Laurenz Albe,
Correct me If am wrong in doing the high availability for postgresql with
two servers win windows postgres 9.1
S1 -Primary
S2 -Standby
S1 -dead, S2- becomes primary
S1-comes back and This should be turned to a new standby --Am I wrong
??--This step is most time taking one, Whi
15 matches
Mail list logo
