Thread: problem about postgresql installation and user login
hi sir, sorry but I'm in trouble as i don't known exactly but postgresql on a system is reset or remove. so when I'm again trying to install postgresql then follow thing happen.. $ sudo apt-get install postgresql [sudo] password for pragmaticvps: Reading package lists... Done Building dependency tree Reading state information... Done The following NEW packages will be installed: postgresql 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 274kB of archives. After this operation, 344kB of additional disk space will be used. WARNING: The following packages cannot be authenticated! postgresql Authentication warning overridden. Get:1 http://debian.newdream.net lenny/main postgresql 8.3.12-0lenny1 [274kB] Fetched 274kB in 0s (4974kB/s) Selecting previously deselected package postgresql. (Reading database ... 158998 files and directories currently installed.) Unpacking postgresql (from .../postgresql_8.3.12-0lenny1_all.deb) ... Setting up postgresql (8.3.12-0lenny1) ... $ sudo su - postgres No directory, logging in with HOME=/ so when I'm trying to install postgresql then above warning got to me and it install. but when I'm trying to login by postgres user then above error it shows. I'm new on ubuntu and openerp so please help we. please tell me steps to solve above problem.. Thanking You OS----->Debian -- View this message in context: http://postgresql.1045698.n5.nabble.com/problem-about-postgresql-installation-and-user-login-tp3335952p3335952.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
On Mon, Jan 10, 2011 at 10:55 PM, somnathzankar <zankarsomnath@gmail.com> wrote: > > $ sudo su - postgres > No directory, logging in with HOME=/ > > so when I'm trying to install postgresql then above warning got to me and it > install. > but when I'm trying to login by postgres user then above error it shows. This just means that the directory /home/postgres wasn't created during installation. I don't think that's a huge problem, though you may want to let the package maintainer about that. Despite that message, you should be logged it as "postgres" and should be able to begin creating databases. > > I'm new on ubuntu and openerp so please help we. > OS----->Debian Ubuntu != Debian. :) It's based on it, but the package repositories are different. So, some advice you read online for Ubuntu may apply to straight Debian, but some may not. In Ubuntu, the "postgresql" package is a meta-package, pointing to the latest version (at this time, "postgresql-8.4" - Ubuntu can be slow to roll to new major versions). -- Daniel J. Summers Owner, DJS Consulting GEEKCODE 3.12 GCS/IT d s-:+ a C++ P--- L++ E--- W++ N++ o? K- w !O M-- V PS+ PE++ Y? PGP- t+ 5? X+ R* tv b+ DI++ D+ G- e<++ h---- r+++ y++++
"Daniel J. Summers" <daniel.summers.2415@gmail.com> writes:
> On Mon, Jan 10, 2011 at 10:55 PM, somnathzankar <zankarsomnath@gmail.com> wrote:
>>
>> $ sudo su - postgres
>> No directory, logging in with HOME=/
>>
>> so when I'm trying to install postgresql then above warning got to me and it
>> install.
>> but when I'm trying to login by postgres user then above error it shows.
> This just means that the directory /home/postgres wasn't created
> during installation.
I wonder whether Ubuntu uses a separate postgresql-server subpackage for
the server-side stuff. If so, that directory would likely belong to the
server package not the core (client-side) package.
regards, tom lane