Dear All, I am totally new to the PostgreSQL. I just installed the PostgreSQL and pgAdmin3 on my Debian system, using the apt-get install command. Apparently, the initial database and the user "postgres" have also been automatically created during the installation. It seems good. But I got b
Hi Rich,
Thank you very much!! Have some further question:
> Please can anyone help me here? I've been so frustrated.:( If there is
> auto-created password
> > for this auto-created postgres user, please anyone tell me what it is?? And
> also otherwise, how
> > can I log-in using the "ident
> > How should I do this? The current auto-generated pg_hba.conf file read as:
> > "local all postgresident sameuser"
> > on the first line, and the first line also after the # TYPE
> > DATABASEMETHOD
> line.
> >
> >
> > Do you mean I should change the "ident sameuser" at the end t
> >
> >
> >>Some examples of pg_hba.conf entries are shown in Example 19-1. See the next
> >>section for details on the different authentication methods.
> >>
> >
> The authentication methods are handled between the libraries (libpq and
> libpxx) and the server. They are transparent to the ap
>Perhaps I wasn't clear.
.
>With identd authentication a username is still specified. But you have
>to own the process to login with that username. So generally speaking
>(absent sudo and the like) you can generally login only with the same
>username as your OS username.
>The documentation
Chris Travers <[EMAIL PROTECTED]> writes:
> Things to check when PostgreSQL doesn't seem to start:
> ...
> In your case, if PostgreSQL is hanging, I would suspect that the problem
> is likely to be with something else. Hopefully there would be info in
> the serverlog that would help.
What I'm
Hi Chris,
thanks for the check list! I just came back from the Debian Recovery mode and
checked all of them. please see below:
>Things to check when PostgreSQL doesn't seem to start:
>1) Are there any postmaster programs running (ps -A | grep postmaster
is useful here)
Checked. No postma
>
>What I'm guessing is that the server started just fine, but the Debian
>initscript is trying to connect to it (to verify that it started) and
>that's failing because of the change in authentication options. You
>might have to remove the -w option from pg_ctl, or some such, in the
>script ... or
>
>>Things to check when PostgreSQL doesn't seem to start:
>>...
>>In your case, if PostgreSQL is hanging, I would suspect that the problem
>>is likely to be with something else. Hopefully there would be info in
>>the serverlog that would help.
>>
>>
>
>What I'm guessing is that the server s
> lmyho <[EMAIL PROTECTED]> writes:
> > In more detail, the logs looks like:
> > ...
> > imcomplete startup packet
> > received fast shutdown request
> > shuttingdown
> > database system is shut down
> > logger shutting down
>
> > So
--- Chris Travers <[EMAIL PROTECTED]> wrote:
> lmyho wrote:
>
> >
> >The last one (successful bootup and shutdown):
> >pg_log# more postgresql-2006-03-30_103237.log
> >2006-03-30 10:32:37 CSTLOG: database system was shut down at 2006-03-30
> >10:
>
> If you su postgres, can you run pg_ctl and get the database up by itself?
By the way, I can run pg_ctl to start the db server only after I links to the
data
directory. Debian's auto startup doesn't go this way but by the it's own
scripts.
leo
___
> > >
> > >
> > Interesting Database starts up at 10:32:37 and processes all
> > databases through autovacuum.
> > Then exactly a minute later, it processes the postgres database.
> > 5 seconds later, you get a SIGINT.
> >
> > Is there something wrong with autovacuum? Normally I would dou
> >
> > Great Scott!! Thank you!! This system was just installed on Debian (2
> > days),
> and
> > the original pg_hba.conf file authen method was "ident sameuser" and
> > appears not
> > allow it to be changed!
> >
> > Look forward to your information!! Thanks a lot!!
>
> Can't find the t
> If by "broken connection" you are referring to the "invalid startup
> packet" lines - that has been known to be caused by pretty much anything
> other than a postgresql client connecting to the pg server port, ie
> portscanner, someone telnetting, net bot, etc.
>
Do you actually mean the "incom
15 matches
Mail list logo
