Forum OpenACS Q&A: /etc/postgresql/postgresql.env: No such file or directory

Collapse
1: /etc/postgresql/postgresql.env: No such file or directory
Posted by Iuri Sampaio on 07/10/06 01:30 AM
I erased the directory /etc/postgresql and now I get this error message every time I run a pgsql command.

yabt@desktop:~$ psql -l

/usr/lib/postgresql/bin/readpgenv: line 2: /etc/postgresql/postgresql.env: No such file or directory

List of databases

Name | Owner | Encoding

-----------+----------+----------

template0 | postgres | LATIN1

template1 | postgres | LATIN1

yabt | yabt | UNICODE

(3 rows)

Does anybody know what packages I should apt-get install to have the directory and file the place again?

iuri

Collapse
2: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 1)
Posted by Vinod Kurup on 07/10/06 02:44 AM
When I need to find which Debian package contains a file, I go to http://packages.debian.org

Scroll down to the bottom of the page and enter the filename in the 'Search the contents of packages' form.

Collapse
3: Re: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 2)
Posted by Iuri Sampaio on 07/10/06 04:04 AM
Sorry i didn't mention everything. I already reinstall postgresql debian pck. But it seems the /etc directory is created with one of the kernels package. I don;t know.

I tried to search by the file was missing but i dind;t get anything

Collapse
4: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 1)
Posted by Torben Brosten on 07/10/06 07:06 AM
Hi Iuri,

I searched for "/etc/postgresql/postgresql.env debian" from postgreql.org and found this, which might help:

http://archives.postgresql.org/pgsql-admin/2005-09/msg00191.php

Collapse
5: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 1)
Posted by Jim Lynch on 07/12/06 07:12 AM
Before doing these, realize and know they are -extreme- actions which you normally should not do... and if you don't know how, you need someone who does to help you.

First, back up the whole data directory (you will have to find out where and how).

Next, purge the postgresql package (which removes config files and possibly database)

Then, install postgresql again

Finally, stop postgresql, remove the existing data directory, restore the backup of the data directlry and restart postgresql

That -might- solve your problem.

Collapse
6: Re: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 5)
Posted by Iuri Sampaio on 07/17/06 10:48 PM
that;s what i did when i said that i had tried to reinstall postgres
the aptget does not install the directory /etc/postgresql

I believe it comes with the debian distro install

so, does it mean i need to install my debian again??

Collapse
7: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 1)
Posted by Torben Brosten on 07/18/06 11:37 AM
Iuri, maybe someone with a debian system can answer your question.
Collapse
8: Re: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 7)
Posted by Iuri Sampaio on 07/19/06 08:55 PM
yes i did post it on the debian-users mailling list. But nobody answered. :(
Collapse
9: Re: Re: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 8)
Posted by Iuri Sampaio on 07/19/06 09:00 PM
anyway I'll keep it posted when i solve this issue
Collapse
10: Re: Re: Re: Re: /etc/postgresql/postgresql.env: No such file or directory (response to 9)
Posted by Iuri Sampaio on 07/20/06 12:35 AM
here it is the answer. run apt-get install the package bellow.

http://packages.debian.org/stable/misc/postgresql-client