Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postfresql 8.4 Problem

Postfresql 8.4 Problem

From
Electric Boy
Date:
I have a problem with posgresql 8.4, yesterday when I tried to reinstall and do restore the old database not work if you install in a different folder than the folder given the old database, the program works. When installing program the old folder where the database service postgresql not start with this log :

2013-01-25 16:32:28 EET LOG:  database system was shut down at 2013-01-25 16:32:11 EET
2013-01-25 16:32:28 EET FATAL:  the database system is starting up
2013-01-25 16:32:29 EET LOG:  database system is ready to accept connections
2013-01-25 16:32:29 EET LOG:  autovacuum launcher started
2013-01-25 16:34:14 EET LOG:  received fast shutdown request
2013-01-25 16:34:14 EET LOG:  aborting any active transactions
2013-01-25 16:34:14 EET LOG:  autovacuum launcher shutting down
2013-01-25 16:34:14 EET LOG:  shutting down
2013-01-25 16:34:14 EET LOG:  database system is shut down

Re: Postfresql 8.4 Problem

From
Pavel Stehule
Date:
Hello

what did you do exactly?

please, can you send more details?

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

Regards

Pavel Stehule


2013/1/25 Electric Boy <electricboy98@yahoo.com>:
> I have a problem with posgresql 8.4, yesterday when I tried to reinstall and
> do restore the old database not work if you install in a different folder
> than the folder given the old database, the program works. When installing
> program the old folder where the database service postgresql not start with
> this log :
>
> 2013-01-25 16:32:28 EET LOG:  database system was shut down at 2013-01-25
> 16:32:11 EET
> 2013-01-25 16:32:28 EET FATAL:  the database system is starting up
> 2013-01-25 16:32:29 EET LOG:  database system is ready to accept connections
> 2013-01-25 16:32:29 EET LOG:  autovacuum launcher started
> 2013-01-25 16:34:14 EET LOG:  received fast shutdown request
> 2013-01-25 16:34:14 EET LOG:  aborting any active transactions
> 2013-01-25 16:34:14 EET LOG:  autovacuum launcher shutting down
> 2013-01-25 16:34:14 EET LOG:  shutting down
> 2013-01-25 16:34:14 EET LOG:  database system is shut down
>

Re: Postfresql 8.4 Problem

From
Adrian Klaver
Date:
On 01/25/2013 07:02 AM, Electric Boy wrote:
> I have a problem with posgresql 8.4, yesterday when I tried to reinstall
> and do restore the old database not work if you install in a different
> folder than the folder given the old database, the program works. When
> installing program the old folder where the database service postgresql
> not start with this log :
>

Questions:

1) Since you are saying folders and service I am assuming you are
talking Windows, Correct?
    If not what platform?

2) If Windows did you use the One Click installer?
    If not how was it installed?

3) What was the original problem that caused you to reinstall?

4) According to the log the database ran for almost two minutes before
it shutdown and did so by request. What happened in those two minutes?

5) Are you sure that you do not have two instances of Postgres running
at the same time? It can be done, but it also can cause problems


--
Adrian Klaver
adrian.klaver@gmail.com