From: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Forgot to dump old data before re-installing machine [solved] |
Date: | 2008-02-01 14:10:03 |
Message-ID: | 497BF87B-577C-4DAF-97B0-19124BC882CB@grid.unep.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-patches |
>>>> When I start the postmaster it seems ok. But there is no process
>>>> running.
>>>
>>> Then it didn't really start successfully. (Unless you use the -w
>>> option, "pg_ctl start" just launches the postmaster --- it doesn't
>>> wait around to see what happens.) You need to look into the log
>>> file to see what the problem was.
>>
>> Ok, it's a bit confusing for a non-admin-user to enter into the pg-
>> config to find out what parameters one has to uncomment in order to
>> get the log working. Succeed after some while, got the postmaster
>> working:
>>
>> 827 p2 S 0:00.22 /usr/local/bin/postmaster -D /usr/local/
>> pgsql/data TERM=xterm-color SHELL=/bin/bash USER=postgres
>> __CF_USER_TEXT_ENCODING=0x1F6:0:0 P
>> 829 p2 S 0:00.01 postgres: writer process
>> 830 p2 S 0:00.00 postgres: stats buffer process
>> 831 p2 S 0:00.00 postgres: stats collector process
>>
>>
>> What would you recommend now in order to get the data back? I have
>> postgis data in the databases too, although this is not too important
>> for me...
>
> Sounds like you're ready to run pg_dump.
Ok, finally got everything working. I really don't understand a thing
about what has happened, since I was running the database since a year
on an Intel Mac.... But perhaps the fact that I moved to Leopard now
made it happen.
Anyway, installing the old postgres version on an old PPC and then re-
importing them into the new Intel-postgres database did the thing.
So, many thanks (!!!!) to everybody (!!!!!) for the valuable inputs,
time etc.
Best wishes,
Stef
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Wetherbee | 2008-02-01 14:22:26 | Re: arrays of floating point numbers / linear algebra operations into the DB |
Previous Message | Stefan Schwarzer | 2008-02-01 13:44:22 | Re: Dump schema without the functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-02-01 14:11:00 | Re: Bitmap index scan preread using posix_fadvise |
Previous Message | Robert Treat | 2008-02-01 04:19:59 | Re: [PATCHES] Better default_statistics_target |