On 07/10/2013 11:53 AM, Wells Oliver wrote:
> I'd like to move the 9.1 database to 9.2 without any down time, and
> ensuring that no data is lost.
>
> My original idea was to make 9.2 a slave of 9.1, then switch it over.
You can't do this with streaming replication. But you can with slony.
Just
On 04/17/2012 07:43 AM, Igor Neyman wrote:
>> -Original Message-
>> From: Chris Ernst [mailto:cer...@zvelo.com]
>> Sent: Monday, April 16, 2012 10:55 PM
>> To: pgsql-admin@postgresql.org
>> Subject: Re: Recreate primary key without dropping foreign keys
On 04/16/2012 07:02 PM, amador alvarez wrote:
> How about deferring the FK's while recreating the PK ?
> or using a temporary parallel table to be pointed by the other tables
> (FK) and swap it up on the recreation.
Hmm.. Interesting. But it appears that you have to declare the foreign
key as de
On 04/16/2012 02:39 AM, Frank Lanitz wrote:
> Am 16.04.2012 10:32, schrieb Chris Ernst:
>> On 04/15/2012 10:57 PM, Frank Lanitz wrote:
>>> On Sun, 15 Apr 2012 18:41:05 -0600 Chris Ernst
>>> wrote:
>>>
>>>> Hi all,
>>>>
>>>>
On 04/15/2012 10:57 PM, Frank Lanitz wrote:
> On Sun, 15 Apr 2012 18:41:05 -0600 Chris Ernst
> wrote:
>
>> Hi all,
>>
>> In PostgreSQL 9.1.3, I have a few fairly large tables with
>> bloated primary key indexes. I'm trying to replace them using
>>
't found a workable solution. Is
there any way to swap in the new index for the primary key constraint
without dropping all dependent foreign keys? Or am I pretty much stuck
with dropping and recreating all of the foreign keys?
Thanks in advance.
Chris Ernst
Data Operations Engineer
Zvelo, Inc.
h
Hi Patrick,
Which pre-built packages (i.e. OS, flavor, architecture, etc...) are you
asking about?
In most cases, you can check the output of pg_config to see if it was
built with "--with-gssapi". You may need to install the PostgresQL
development packages, depending on your environment.
Hope t
On 08/11/2011 08:41 AM, CS DBA wrote:
> Hi All;
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
>
>
> Thanks in advance...
>
I believe EnterpriseDB Advanced Server does it
(http://www.enter
SET work_mem='1GB'; (or whatever size makes sense)
- Chris
On 06/13/2011 10:29 AM, Dinesh Bhandary wrote:
> Hi All -
>
> Is there a way to change work_mem for a session in postgres without
> restarting a database? Please let me know.
>
> Thanks.
> Dinesh
>
--
Sent via pgsql-admin mailing
On 04/24/2011 04:21 PM, David Hornsby wrote:
> My SMB database is currently running on a HP-UX box running in a master
> - slave slonyI cluster to create a hot spare database. Recently the
> server has be getting hammered and we are consistently hitting our max
> db connections. We have our web CMS
10 matches
Mail list logo
