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.muk...@hotmail.fr To: vili0...@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 Hello Viktor, 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.muk...@hotmail.fr Date: Fri, 12 Nov 2010 11:34:04 +0100 Subject: Re: [HACKERS] TODO Alter Table Rename Constraint From: vili0...@gmail.com To: aime.muk...@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.muk...@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.muk...@hotmail.fr Date: Fri, 12 Nov 2010 10:28:25 +0100 Subject: Re: [HACKERS] TODO Alter Table Rename Constraint From: vili0...@gmail.com To: robertmh...@gmail.com CC: pgsql-hack...@postgresql.org; chris....@gmx.at OK, I see. Thanks for mentioning it.Are there other problems with the suggestion? Or should the work like that? Viktor 2010/11/10 Robert Haas <robertmh...@gmail.com> On Wed, Nov 10, 2010 at 6:32 AM, Viktor Valy <vili0...@gmail.com> wrote: > 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? Indexes can't be inherited, so the problem doesn't arise in that case. > Is there a solution for the test-cases you have posted? Or is this yet a > problem? We had a bug related to the handling of ALTER TABLE .. ADD/DROP 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. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
