Обсуждение: FW: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7.
FW: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7.
От
Aimé Mukuma
Дата:
Please, can you help me to "replicate postgresql 8.2.9 on using Linux Fedora core 7".
The problem is to replicate the postgresql database on master server to a slave server in using postgresql 8.2.9 on Linux fedora core 7.
I need your help, please.
From: aime.mukuma@hotmail.fr
To: vili0121@gmail.com
Subject: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7.
Date: Fri, 12 Nov 2010 12:11:41 +0100
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Tahoma;}
Hello Viktor,
From: aime.mukuma@hotmail.fr
To: vili0121@gmail.com
Subject: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7.
Date: Fri, 12 Nov 2010 12:11:41 +0100
My problem is so simple than I can understand it easily. I need to know (if you can give some code) " how to replicate postgresql 8.2.9 on using Linux Fedora core 7" because I am using postgresql for doing my paper (memorial university) in the university.
Please help me do it.
I need docs or line code.
Note : I don't write better than you do but I understand you very.
Aimé MUKUMA NGANDU
TEL. +243 813411883 - +243 895102090
E-mail : aime.mukuma@hotmail.fr
Date: Fri, 12 Nov 2010 11:34:04 +0100
Subject: Re: [HACKERS] TODO Alter Table Rename Constraint
From: vili0121@gmail.com
To: aime.mukuma@hotmail.fr
You need some lines of code for replicate postgresql?
Aimé MUKUMA NGANDU
TEL. +243 813411883 - +243 895102090
E-mail : aime.mukuma@hotmail.fr
Date: Fri, 12 Nov 2010 11:34:04 +0100
Subject: Re: [HACKERS] TODO Alter Table Rename Constraint
From: vili0121@gmail.com
To: aime.mukuma@hotmail.fr
You need some lines of code for replicate postgresql?
I'm sorry, I don't really get it, can you explain it more detailed?
If you are interested in the approach to rename constraints, look at the source (src/backend/commands/tablecmds.c function: RenameRelationInternal line 2196) where you can find it for indexes, tables, views, etc. In my suggestion it should work the same way.
Viktor
2010/11/12 Aimé Mukuma <aime.mukuma@hotmail.fr>
I was talking about how to replicate postgresql 8.2.9 on linux fedora.I need some lines code if it's possible.
Aimé MUKUMA NGANDU
TEL. +243 813411883 - +243 895102090
E-mail : aime.mukuma@hotmail.fr
Date: Fri, 12 Nov 2010 10:28:25 +0100
Subject: Re: [HACKERS] TODO Alter Table Rename Constraint
From: vili0121@gmail.com
To: robertmhaas@gmail.com
CC: pgsql-hackers@postgresql.org; chris.gut@gmx.at
OK, I see. Thanks for mentioning it.Are there other problems with the suggestion? Or should the work like that?Viktor2010/11/10 Robert Haas <robertmhaas@gmail.com>On Wed, Nov 10, 2010 at 6:32 AM, Viktor Valy <vili0121@gmail.com> wrote:Indexes can't be inherited, so the problem doesn't arise in that case.
> Thanks for your answer!
> I'm not really familiar with inheritance, but I wonder how this issue
> is handled in other cases, for instance renaming an index, which invokes
> internal a constraint rename too. Is that relevant or is the renaming of
> constraints so special?We had a bug related to the handling of ALTER TABLE .. ADD/DROP
> Is there a solution for the test-cases you have posted? Or is this yet a
> problem?
CONSTRAINT for those test cases, which I fixed. I think we still have
a similar problem with ALTER TABLE .. ADD/DROP ATTRIBUTE, which I
haven't fixed because it's hard and I haven't had time, and no one
seems to care that much. My point was just that whatever patch you
come up with for ALTER TABLE .. RENAME CONSTRAINT should probably be
tested against those cases to see if it behaves correctly.
--