Re: [GENERAL] Win32 8.3.3 install fail (sufficient privileges to

2008-06-12 Thread Terry Yapt
Raymond O'Donnell escribió: On 12/06/2008 18:21, Terry Yapt wrote: I did installed 8.3.1 on WinXP Prof. and all was ok. After that successful install I have tried to install 8.2.x without success several times on the same workstation. Today I have tried to install 8.3.3 and I have

Re: [GENERAL] Win32 8.3.3 install fail (sufficient privileges to

2008-06-12 Thread Terry Yapt
Raymond O'Donnell escribió: On 12/06/2008 18:21, Terry Yapt wrote: I did installed 8.3.1 on WinXP Prof. and all was ok. After that successful install I have tried to install 8.2.x without success several times on the same workstation. Today I have tried to install 8.3.3 and I have

[GENERAL] Win32 8.3.3 install fail (sufficient privileges to install system services).

2008-06-12 Thread Terry Yapt
I did installed 8.3.1 on WinXP Prof. and all was ok. After that successful install I have tried to install 8.2.x without success several times on the same workstation. Today I have tried to install 8.3.3 and I have stuck on the same error: === Service 'PostgreSQL Database Server

Re: [GENERAL] FATAL: could not reattach to shared memory

2007-10-24 Thread Terry Yapt
Bruce Momjian escribió: This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold Update: I have installed PostgreSQL 8.2.5 and move database from old to new server. This was 2 weeks ago. New Server is a Windows 2003 Server running other service

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-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.

[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

Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)

2007-08-26 Thread Terry Yapt
Trevor Talbot escribió: The environment is consistent then. Whatever is going on, when postgres first starts things are normal, something just changes later and the change is temporary. As vague guides, I would look at some kind of global resource usage/tracking, and scheduled tasks. Do you se

Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)

2007-08-24 Thread Terry Yapt
Tom Lane escribió: I'm not sure if you have a specific technical meaning of "clone" in mind here, but these processes are all executing the identical executable, and taking care to map the shmem early in execution *before* they load any DLLs. So it should work. Apparently, it *does* work for aw

Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)

2007-08-23 Thread Terry Yapt
Alvaro Herrera escribió: Terry Yapt wrote: This is the main error: * FATAL: could not reattach to shared memory (key=5432001, addr=01D8): Invalid argument It is always followed by this another system-app error: * LOG: unrecognized win32 error code: 487 This problem has been

Re: [GENERAL] FATAL: could not reattach to shared memory (Win32)

2007-08-23 Thread Terry Yapt
gs. Alvaro Herrera escribió: Terry Yapt wrote: I am looking for system errors and nothing is there. But I have a lot of messages on system APP errors. The error is the same every ten seconds or so. This is the main error: * FATAL: could not reattach to shared memory (key=5432001, addr

[GENERAL] FATAL: could not reattach to shared memory (Win32)

2007-08-23 Thread Terry Yapt
Hello all, I am having problems with the next postgresql version: pg version: 8.2.4 OS: Win32 (windows xp sp2) FS: NTFS It is a production server, but suddenly the DB stop answering to any sql command. It seems dead. After restart server all starts to works again. I am looking for system e

Re: [GENERAL] [Windows] Pg_Restore on 8.1.5 and so on...

2006-11-30 Thread Terry Yapt
Terry Yapt wrote: > Terry Yapt wrote: > > > Terry Yapt wrote: > > > > > I am trying to restore from a pg_dump. Pg_restore is doing some > > > strange behaviour. > > > > > > If I open a CMD shell console and execute pg_restore, nothing is &

Re: [GENERAL] [Windows] Pg_Restore on 8.1.5 and so on...

2006-11-30 Thread Terry Yapt
Terry Yapt wrote: > Terry Yapt wrote: > > > I am trying to restore from a pg_dump. Pg_restore is doing some > > strange behaviour. > > > > If I open a CMD shell console and execute pg_restore, nothing is > > showed. If I try to do a "with sense" p

[GENERAL] [Windows] Pg_Restore on 8.1.5 and so on...

2006-11-28 Thread Terry Yapt
I am trying to restore from a pg_dump. Pg_restore is doing some strange behaviour. If I open a CMD shell console and execute pg_restore, nothing is showed. If I try to do a "with sense" pg_restore, nothing is showed in spite of I have put --verbose option. This is my complete command: pg_resto

Re: [GENERAL] [Windows] Pg_Restore on 8.1.5 and so on...

2006-11-28 Thread Terry Yapt
Terry Yapt wrote: > I am trying to restore from a pg_dump. Pg_restore is doing some > strange behaviour. > > If I open a CMD shell console and execute pg_restore, nothing is > showed. If I try to do a "with sense" pg_restore, nothing is showed > in spite of

Re: [GENERAL] Pgsql beta 8 on windows starts and stops automatically.

2004-08-24 Thread Terry Yapt
That's right.. I have deleted postmaster.pid and all was ok now.. Thanks.. On Mon, 23 Aug 2004 10:35:00 +0200, [EMAIL PROTECTED] ("Magnus Hagander") wrote: >> Hello all, >> >> I am testing PostgreSQL 8.0 beta on a windows xp >> professional. In the time when I did the install I have been

[GENERAL] Pgsql beta 8 on windows starts and stops automatically.

2004-08-23 Thread Terry Yapt
Hello all, I am testing PostgreSQL 8.0 beta on a windows xp professional. In the time when I did the install I have been working with pgadmin and so on... But after a few days, when I tried to continue with my tests. I cannot start the postgresql service. I always get this message windown when

Re: [GENERAL] Localization Oracle vs. Postgresql

2003-08-29 Thread Terry Yapt
>Now I want to know if it is possible (when yes the how?) in Postgresql >To set dynamically the Localization? >For example in Oracle you can set the Localization for dates like this >Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America SET DATESTYLE TO NonEuropean; > >This example

Re: [GENERAL] Localization Oracle vs. Postgresql

2003-08-29 Thread Terry Yapt
>For example in Oracle you can set the Localization for dates like this >Alter session set NLS_DATE_LANGUAGE=American NLS_TERRITORY=America SET DATESTYLE TO NonEuropean; >This example would set the Date-Localization to American but only for the actual >session. This one too I think so. >Is so