FW: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7.

[Aimé Mukuma <aime.mukuma@xxxxxxxxxx>]

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@xxxxxxxxxx
To: vili0121@xxxxxxxxx
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.mukuma@xxxxxxxxxx

---

---

Date: Fri, 12 Nov 2010 11:34:04 +0100
Subject: Re: [HACKERS] TODO Alter Table Rename Constraint
From: vili0121@xxxxxxxxx
To: aime.mukuma@xxxxxxxxxx

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@xxxxxxxxxx>

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@xxxxxxxxxx

---

---

Date: Fri, 12 Nov 2010 10:28:25 +0100
Subject: Re: [HACKERS] TODO Alter Table Rename Constraint
From: vili0121@xxxxxxxxx
To: robertmhaas@xxxxxxxxx
CC: pgsql-hackers@xxxxxxxxxxxxxx; chris.gut@xxxxxx

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 <robertmhaas@xxxxxxxxx>

On Wed, Nov 10, 2010 at 6:32 AM, Viktor Valy <vili0121@xxxxxxxxx> 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