[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: postgresql



> 7.1.3-6 I presume?

Yes (I have tried 7.1.3-7 from unstable too, it looks like the same)

(a bit from) ps -j -u root:
-----
-----
26738 26735 26716 ttyp1    00:00:03 dpkg
26738 26735 26716 ttyp1    S      0:03 dpkg -i postgresql_7.1.3-6_i386.deb
-----
-----
26799 26735 26716 ttyp1    00:00:00 postgresql.post
26799 26735 26716 ttyp1    S      0:00 /bin/bash
 /var/lib/dpkg/info/postgresql.postinst configure 7.1.2-1
-----
-----

(all from) ps -j -u postgres:
  PID  PGID   SID TTY          TIME CMD
-----
-----
26857 26735 26716 ttyp1    00:00:00 postmaster
26857 26735 26716 ttyp1    S      0:00 /usr/lib/postgresql/bin/postmaster
 -D /var/lib/postgres/data
-----
-----
26867 26735 26716 ttyp1    00:00:00 enable_lang
26867 26735 26716 ttyp1    S      0:00 /bin/bash
/usr/lib/postgresql/bin/enable_lang plpgsql --all
-----
-----
26894 26735 26716 ttyp1    00:00:00 psql
26894 26735 26716 ttyp1    S      0:00 /usr/lib/postgresql/bin/psql -q -t
-c select count(*) from pg_language where lanname='plpgsql' -d bk
-----
-----

bk is from pg_hba.conf:
local        bk                                            password bk
host         bk          127.0.0.1     255.0.0.0           password bk

Thus, I just removed these two lines, but it stops on the same, but
"bkwww" (well, it is in pg_hba.conf, it was there before bk remove too)

apropos, now (during new install, after bk remove), it writes (it is the
last message before the hang):

plpgsql is already enabled in bk



Reply to: