Re: [GENERAL] windows and pg 8.2 (change database to another server)

2007-10-07 Thread Terry Yapt
Hi Magnus and all people... And yes, it shoul dbe set on the file and all subdirs. Use the checkbox to overwrite all permissions on subdirs, that's the fastest way. //Magnus Sorry my delay but I was very busy last week. In general, giving windows Postgres user Change right do the trick bu

Re: [GENERAL] windows and pg 8.2 (change database to another server)

2007-10-02 Thread Magnus Hagander
On Mon, Oct 01, 2007 at 11:38:53PM +0200, Terry Yapt wrote: > Magnus Hagander escribió: > >On Sun, Sep 30, 2007 at 11:36:23PM +0200, Terry Yapt wrote: > >>First of all. I think this method is admisible. Isn't it ? > >> > > > >It is. > > > > Glad to read it :-) > > >>And second questio

Re: [GENERAL] windows and pg 8.2 (change database to another server)

2007-10-01 Thread Terry Yapt
Magnus Hagander escribió: On Sun, Sep 30, 2007 at 11:36:23PM +0200, Terry Yapt wrote: First of all. I think this method is admisible. Isn't it ? It is. Glad to read it :-) And second question: I think my problem is that some rights are wrong after copying data folder. What a

Re: [GENERAL] windows and pg 8.2 (change database to another server)

2007-10-01 Thread Magnus Hagander
On Sun, Sep 30, 2007 at 11:36:23PM +0200, Terry Yapt wrote: > Hello all, > > I would like to change a pg database to another server. > > The source environment is: postgresql Windows v.8.2.4 (windows xp > workstation). > The target environment is: postgresql Windows v.8.2.5 (windows 2003 Server)

[GENERAL] windows and pg 8.2 (change database to another server)

2007-09-30 Thread Terry Yapt
Hello all, I would like to change a pg database to another server. The source environment is: postgresql Windows v.8.2.4 (windows xp workstation). The target environment is: postgresql Windows v.8.2.5 (windows 2003 Server). I would like to do migration without pg_dumpall and I think I can do