Обсуждение: problem

Поиск
Список
Период
Сортировка

problem

От
"Elwyn"
Дата:
 
Dear all,
 
Thank you for your support. i have face a problem here. when i try to input
 
Error
1) postmaster -D mydb
 
error message will display as below
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version 7.2, which is not compatible with this version 7.4.1.
DEBUG: startup process <pid 1620) exited abnormally
DEBUG: aborting startup due to startup process failure
 
2) createdb mydb
 
error message will display as below
createdb: could not connect to database template1: could not connect to server:
Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5432?
 
These 2 above are the error that i currently face. please give me some suggestion on what should i do to correct these error.
 
Thank you.
 
Regards,
Elwyn

Re: problem

От
Robert Treat
Дата:
Hmm... didn't see any answers to this (probably should have been posted to
-general or -admin) but imho I think you need to install a copy of postgresql
7.2, start that up pointing at your exisisting data files, then dump the
database and load it into your 7.4 version.

Robert Treat

On Tuesday 01 June 2004 03:00, Elwyn wrote:
> Dear all,
>
> Thank you for your support. i have face a problem here. when i try to input
>
> Error
> 1) postmaster -D mydb
>
> error message will display as below
> FATAL: database files are incompatible with server
> DETAIL: The data directory was initialized by PostgreSQL version 7.2, which
> is not compatible with this version 7.4.1. DEBUG: startup process <pid
> 1620) exited abnormally
> DEBUG: aborting startup due to startup process failure
>
> 2) createdb mydb
>
> error message will display as below
> createdb: could not connect to database template1: could not connect to
> server: Connection refused
>         Is the server running on host "localhost" and accepting
>         TCP/IP connections on port 5432?
>
> These 2 above are the error that i currently face. please give me some
> suggestion on what should i do to correct these error.
>
> Thank you.
>
> Regards,
> Elwyn

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL