Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread G. P.
-install this account? thx george From: Craig Ringer cr...@postnewspapers.com.au To: G. P. pagomen2...@yahoo.gr Cc: salah jubeh s_ju...@yahoo.com; pgsql-general@postgresql.org Sent: Wed, May 18, 2011 3:52:07 AM Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data?? On 18/05/2011 7

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread Thierry Hauchard
Hi, We experienced similar problem : it was just the encoding of pg_hba.conf that was accidentally changed when modifying it (UTF8/ansi) Thierry Le 18/05/2011 09:28, G. P. a écrit : Hi Craig,All when i try from the service control panel I get an *1053 error : the service did not respond

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread G. P.
Hi Thierry, The encoding is ansi. Should I save them as UTF8? From: Thierry Hauchard gesteam_...@gesteam.fr To: pgsql-general@postgresql.org Sent: Wed, May 18, 2011 10:46:51 AM Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data?? Hi, We

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread Craig Ringer
On 05/18/2011 03:46 PM, Thierry Hauchard wrote: Hi, We experienced similar problem : it was just the encoding of pg_hba.conf that was accidentally changed when modifying it (UTF8/ansi) The encoding should not matter unless there are characters above byte 128, because UTF-8 and the ANSI

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread G. P.
@postgresql.org Sent: Wed, May 18, 2011 12:46:11 PM Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data?? On 05/18/2011 03:46 PM, Thierry Hauchard wrote: Hi, We experienced similar problem : it was just the encoding of pg_hba.conf that was accidentally changed when modifying it (UTF8

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread John R Pierce
On 05/18/11 4:31 AM, G. P. wrote: can I download from somewhere clean pg_hba.conf / postgresql.conf with default values, just to ensure that the failure is caused by them ? those files are created by initdb just run initdb on a scratch directory -- Sent via pgsql-general mailing list

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread G. P.
Finally i re-installed PostgreSQL everything seems to be OK! From: John R Pierce pie...@hogranch.com To: pgsql-general@postgresql.org Sent: Wed, May 18, 2011 5:34:05 PM Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data?? On 05/18/11 4

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-18 Thread Craig Ringer
On 05/18/2011 07:31 PM, G. P. wrote: can I download from somewhere clean pg_hba.conf / postgresql.conf with default values, just to ensure that the failure is caused by them ? AFAIK they're generated by the installer, as they contain paths specific to your installation. So not really. It

[GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-17 Thread G. P.
Hi, I have installed postres/postgis 9 in win7. I tried to edit pg_hba.conf not as postgres user and although i cancelled all changes I can start my postgres any more.. Now I am thinking of re-installing postgresql but for sure i dont loose my data ... Any ideas ? Thx George

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-17 Thread G. P.
failure Thats why i am considering to re-install postgres From: salah jubeh s_ju...@yahoo.com To: G. P. pagomen2...@yahoo.gr Sent: Wed, May 18, 2011 1:05:38 AM Subject: Re: [GENERAL] re-install postgres/postGIS without Loosing data?? Have a look on http

Re: [GENERAL] re-install postgres/postGIS without Loosing data??

2011-05-17 Thread Craig Ringer
On 18/05/2011 7:13 AM, G. P. wrote: C:\Program Files\PostgreSQL\9.0\binpg_ctl.exe -U postgres restart pg_ctl: PID file C:/Program Files/PostgreSQL/9.0/data/postmaster.pid */2011-05-18 02:09:26 EEST LOG: database system was shut down at 2011-05-17 22:45:00 EEST/* */2011-05-18 02:09:36 EEST