pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
problem about postgresql installation and user login 3+ messages / 3 participants [nested] [flat]
* problem about postgresql installation and user login @ 2011-01-11 05:55 somnathzankar <zankarsomnath@gmail.com> 2011-01-11 17:07 ` Re: problem about postgresql installation and user login Daniel J. Summers <daniel.summers.2415@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: somnathzankar @ 2011-01-11 05:55 UTC (permalink / raw) To: pgsql-admin 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-tp33359... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: problem about postgresql installation and user login 2011-01-11 05:55 problem about postgresql installation and user login somnathzankar <zankarsomnath@gmail.com> @ 2011-01-11 17:07 ` Daniel J. Summers <daniel.summers.2415@gmail.com> 2011-01-11 17:42 ` Re: problem about postgresql installation and user login Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 3+ messages in thread From: Daniel J. Summers @ 2011-01-11 17:07 UTC (permalink / raw) To: somnathzankar <zankarsomnath@gmail.com>; +Cc: pgsql-admin 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++++ ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: problem about postgresql installation and user login 2011-01-11 05:55 problem about postgresql installation and user login somnathzankar <zankarsomnath@gmail.com> 2011-01-11 17:07 ` Re: problem about postgresql installation and user login Daniel J. Summers <daniel.summers.2415@gmail.com> @ 2011-01-11 17:42 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2011-01-11 17:42 UTC (permalink / raw) To: Daniel J. Summers <daniel.summers.2415@gmail.com>; +Cc: somnathzankar <zankarsomnath@gmail.com>; pgsql-admin "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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-01-11 17:42 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-01-11 05:55 problem about postgresql installation and user login somnathzankar <zankarsomnath@gmail.com> 2011-01-11 17:07 ` Daniel J. Summers <daniel.summers.2415@gmail.com> 2011-01-11 17:42 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox