[ADMIN] pg_top problem

2009-05-14 Thread S Arvind
after installing pg_top, when i tried to start it, i got this msg, how to solve it # pg_top pg_top: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory --Arvind S * "Many of lifes failure are people who did not realize how close they were t

[ADMIN] Replication for migration

2009-05-14 Thread Martin Spinassi
Hi list! I've to do a migration of postgresql from version 8.2 to 8.3 in one server. The problem I see here is, to avoid data loss (people still using the web site that uses postgres), I'll need to stop postgres 8.2, make a pg_dumpall, and then restore that information in 8.3. Taking some consider

Re: [ADMIN] Replication for migration

2009-05-14 Thread Kenneth Marshall
On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote: > Hi list! > > I've to do a migration of postgresql from version 8.2 to 8.3 in one > server. The problem I see here is, to avoid data loss (people still > using the web site that uses postgres), I'll need to stop postgres 8.2, > make

Re: [ADMIN] Replication for migration

2009-05-14 Thread Martin Spinassi
On Thu, 2009-05-14 at 08:59 -0500, Kenneth Marshall wrote: > On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote: > > Hi list! > > [snip] > > > > I'd love to read some experiences or advices, since I haven't done it > > before. Also if you have some link o document that you think I mu

Re: [ADMIN] Replication for migration

2009-05-14 Thread Dimitri Fontaine
Hi, Martin Spinassi writes: > On Thu, 2009-05-14 at 08:59 -0500, Kenneth Marshall wrote: >> I used Slony replication to upgrade a database from 8.2 -> 8.3 and >> it worked quite well. You will need an outage to change the master >> to the 8.3 database and re-point your apps, but if scripted, tha

Re: [ADMIN] pg_top problem

2009-05-14 Thread Devrim GÜNDÜZ
On Thu, 2009-05-14 at 14:57 +0530, S Arvind wrote: > after installing pg_top, when i tried to start it, i got this msg, how > to solve it > > # pg_top > pg_top: error while loading shared libraries: libpq.so.5: cannot open > shared object file: No such file or directory So libpq.so.5 is not in yo

Re: [ADMIN] pg_top problem

2009-05-14 Thread S Arvind
Thanks Devrim, I can understand the prob, but when i tried to use the second method it raises the same error. And the first method can u tell me how to add the libpq.so.5 in conf file? since i am new to linux , so i dont know more about it... currently that file has only one line include ld.so

Re: [ADMIN] pg_top problem

2009-05-14 Thread S Arvind
Devrim i found out and its working fine... Very thanks... -Arvind S * "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison* On Thu, May 14, 2009 at 10:00 PM, S Arvind wrote: > Thanks Devrim, > I can understand the prob, bu

Re: [ADMIN] Replication for migration

2009-05-14 Thread Scott Marlowe
On Thu, May 14, 2009 at 7:59 AM, Kenneth Marshall wrote: > On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote: >> Hi list! >> >> I've to do a migration of postgresql from version 8.2 to 8.3 in one >> server. The problem I see here is, to avoid data loss (people still >> using the web