Re: [ADMIN] using ssl some of the time

Bruce Momjian wrote: Charles Hornberger wrote: On Wed, 23 Jul 2003, Bruce Momjian wrote: Charles Hornberger wrote: Am I right in interpreting this to mean that I either have to use SSL all the time or none of the time? I'm especially tempted to believe this might be the case after s

Re: [ADMIN] using ssl some of the time

On Wed, 23 Jul 2003, Bruce Momjian wrote: > Charles Hornberger wrote: > > Am I right in interpreting this to mean that I either have to use SSL > > all the time or none of the time? I'm especially tempted to believe > > this might be the case after seeing this ite

[ADMIN] using ssl some of the time

I'm having a bit of trouble understanding exactly how SSL-encrypted connections are supposed to work -- and specifically whether it's possible to "use SSL some of the time." Here's what I want to do: 1) I want one of my web servers to be able to connect to the database without the overhead of

Re: [ADMIN] Tracing used SQL statments

g the crash I might be able to fix the problem. Thanks Matthew -- Charles Hornberger Caltech Division of the Humanities and Social Sciences M/C 228-77 Tel (626) 395-3474 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] postmaster dead but backends still running?

On Thu, 19 Jun 2003, Tom Lane wrote: > Charles Hornberger <[EMAIL PROTECTED]> writes: > > However, I think I know the cause (though I haven't tested to see if this > > indeed causes the postmaster to die): A few hours before I noticed that > > the postmaster was d

Re: [ADMIN] postmaster dead but backends still running?

On Tue, 17 Jun 2003, Tom Lane wrote: > Charles Hornberger <[EMAIL PROTECTED]> writes: > > Other things I perhaps ought to mention: Trying to stop the postmaster > > using pg_ctl fails (unsurprisingly, since pg_ctl relies on > > /var/pgsql/data/postmaster.pid, which con

Re: [ADMIN] postmaster dead but backends still running?

out a dozen a day), but I can't find any other related messages in the logs. If anyone has any suggestions, I'd really appreciate your input; I'm getting a bit antsy since my production database server is basically halfway down and users are wondering why their web pages don't work

[ADMIN] postmaster dead but backends still running?

ect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432? Any ideas on what I should do now? I'm running 7.3.2 on Solaris 7. -Charlie -- Charles Hornberger Caltech Division of the Humanities and Social Sciences M/C 228-

Re: [ADMIN] PostgreSQL 7.2 + PAM = authentication failure?

nyone out there actually managed to get PAM authentication (via pam_unix.so) working? Thanks (again) in advance for any help, hints, tips, advice, words of sympathy, etc. -Charlie On Fri, 2003-02-07 at 17:12, Charles Hornberger wrote: > Hello -- > > I'm trying to get PostgreSQL to u

[ADMIN] PostgreSQL 7.2 + PAM = authentication failure?

3.php that PAM authentication failures might have something to do with MD5-encrypted passwords in pg_shadow, but I can't understand how the contents of pg_shadow would affect PAM authentication. In any case, I haven't tried applying the patch that was provided there. Should I? -- Char