Solved. For now.
-> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
such file or directory
I copied this folder from another postgres installation i did some
months back on another system and wham, up and running agan.
weird.
------
On Sun, Nov 29, 2009 at 11:27 AM, CyTG <cytg.net@gmail.com> wrote:
> Hi, i recently migrated from mysql to postgres and i might have made a
> no-no in that process.
> bascily i want/need a selfcontained folder \database where i can zip
> that directory move it anywhere, unzip and carry on my busniess with
> no dependencies. Postgres presented me with a challenge in this regard
> as i am not allowed to run it from a admin account (yes i know i know,
> still..), alas i followed the steps here
> http://charupload.wordpress.com/2008/07/26/manual-installation-of-postgresql-under-administrator-user-in-windows/
>
> initdb -D c:\postgresql\data
> pg_ctl.exe start -D c:\postgresql\data
>
> Fantastic, i was up and running, migrated my data and continued
> developent .. the server have stopped on occasion on its own for some
> reason i cannot pinpoint, but now it is totally unable to start up,
> here is the recent entries from the server log.
>
> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
> such file or directory
> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
> such file or directory
> FATAL: could not select a suitable default timezone
> DETAIL: It appears that your GMT time zone uses leap seconds.
> PostgreSQL does not support leap seconds.
> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
> such file or directory
> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
> such file or directory
> FATAL: could not select a suitable default timezone
> DETAIL: It appears that your GMT time zone uses leap seconds.
> PostgreSQL does not support leap seconds.
> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
> such file or directory
> LOG: could not open directory "G:/mysql/pgsql/share/timezone": No
> such file or directory
> FATAL: could not select a suitable default timezone
> DETAIL: It appears that your GMT time zone uses leap seconds.
> PostgreSQL does not support leap seconds.
>
> Dont put anything onto the g:/mysql directory, inhere mysql and
> postgres lives side by side...
> I understand the error, the directory is NOT there ... but this thing
> was running happily a few days ago .. what went wrong ???
>
