Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Problem. cr...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 15265 of 17598
Post > Topic >>

Re: Problem. createdb: could not connect to database postgres:

by craig@[EMAIL PROTECTED] (Craig Ringer) Apr 12, 2008 at 02:36 PM

Jaisen N.D. wrote:
> Hai, I use Debian Etch. I have a problem with postgresql 8.1. I have
> uninstalled the postgresql-8.3, which I was took from debian back ****ts,
> removed its configuration files, and the user postgres also.
It sounds like you didn't remove the data directory, 
/var/lib/postgresql/data .

By the way, if you want to remove all configuration etc along with a 
package you should use apt-get --purge remove .
> initdb: directory "/var/lib/postgresql/data" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/var/lib/postgresql/data" or run initdb
> with an argument other than "/var/lib/postgresql/data".
>   
initdb could not create a database cluster because there were files in 
/var/lib/postgresql/data . You should rename the `data' directory to 
something else or remove it. Removing it will destroy your database.

PostgreSQL 8.1 cannot read data from PostgreSQL 8.3 .

> postgres@[EMAIL PROTECTED]
 /usr/lib/postgresql/8.1/bin/pg_ctl -D
> /var/lib/postgresql/data -l logfile start
> postmaster starting
>   
If you have a look at the postgresql logs you will see that postgresql 
failed to start because it cannot read the data in the data directory; 
it is for the wrong version of postgresql.

--
Craig Ringer

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 2 Posts in Topic:
Re: Problem. createdb: could not connect to database postgres:
craig@[EMAIL PROTECTED]   2008-04-12 14:36:08 
Re: Problem. createdb: could not connect to database postgres: c
kleptog@[EMAIL PROTECTED]  2008-04-19 11:23:16 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 8:34:33 CST 2008.