Re: [GENERAL] Ubuntu, Postgresql-8.2 and remote access thru pg_hba.conf

2007-06-17 Thread MC Moisei
duh!listen_addresses = '*'I must add that having to modify both files for remote access is a bit misleading, and I didn't set at least 4 postgresql servers before...From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [GENERAL] Ubuntu, Postgresql-8.2 and remote access thru pg_hba.confDate: Mon, 18 Jun 20

[GENERAL] Ubuntu, Postgresql-8.2 and remote access thru pg_hba.conf

2007-06-17 Thread MC Moisei
Hi,I just want to say that ubuntu team done an excelent job integration the penultimate version of postgresql in spite of the fact that I was running 7.4.7 it manages to install 8.2 in paralel without affecting my production version. There is one single thing that bothers me big time - I cannot

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-15 Thread MC Moisei
Thanks for replying! I will try to upgrade to the latest on my prod box. Any easy way to do that ? Can I have two releases in the same time 7.4.7 and 8.2.3 ? This is a phased approach so it may take a little while to do it and I want to have 7.4.7 till I'd be able to switch to the 8.2.3( on a di

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-15 Thread MC Moisei
ster processes taking all the CPU> > On Fri, Jun 08, 2007 at 05:08:26PM -0500, MC Moisei wrote:> > Yes all the connection are coming from within the box so no network> > latency.Well, isn't the swap can be because too many process> > postmaster are requiring more mem

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread MC Moisei
l@postgresql.org> Subject: Re: [GENERAL] Postmaster processes taking all the CPU> > First, your mail is coming through really garbled. Maybe you need to> add some linebreaks or something? Anyway> > On Fri, Jun 08, 2007 at 03:58:40PM -0500, MC Moisei wrote:> > > > I

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread MC Moisei
t a reqular vacuum?> > - Ericson Smith> Developer> http://www.funadvice.com> > On 6/8/07, Andrew Sullivan <[EMAIL PROTECTED]> wrote:> > On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote:> > >> > > pack of postmaster(4-22) processes ran by

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread MC Moisei
n 2007 16:35:40 -0400> From: [EMAIL PROTECTED]> To: pgsql-general@postgresql.org> Subject: Re: [GENERAL] Postmaster processes taking all the CPU> > On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote:> > > > pack of postmaster(4-22) processes ran by postgres user a

Re: [GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread MC Moisei
Anyone ?From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [GENERAL] Postmaster processes taking all the CPUDate: Fri, 8 Jun 2007 13:23:00 -0500 Hi,I have this server that I use as db server. It's decent box Ubuntu, 2GB, AMD Barton 2.8Gb L2 2Mb. DB version is 7.4.7 - that version was the only o

[GENERAL] Postmaster processes taking all the CPU

2007-06-08 Thread MC Moisei
Hi,I have this server that I use as db database. It's decent box Ubuntu, 2GB, AMD Barton 2.8Gb L2 2Mb. DB version is 7.4.7 - that version was the only one available at that time. I have it for about 2 years in similar configuration. Lately I've notices that a pack of postmaster(4-22) process

Re: [GENERAL] Mapping/DB Migration tool

2006-07-25 Thread MC Moisei
work. The contraints are easy to migrate once I have the whole structure in place. Thanks a lot to all for replying to my post that quickly. Keep them coming if you have more ideas Regards, Constantin http://www.goodstockimages.com From: Reece Hart <[EMAIL PROTECTED]> To: MC Moisei &

[GENERAL] Mapping/DB Migration tool

2006-07-25 Thread MC Moisei
Hi, I'm looking to migrate psql db1 to a psql db2 that has a different structure even though 70% would be the same. I'd need a tool that allows me to map field to field and then migrate the data from one db to another. Needless to say that preserving data integrity is very important. Any goo