Package: postgresql-8.1
Version: 8.1.9-0etch1
1. I stopped the server:
/etc/init.d/postgresql-8.1 stop
2. I changed the default data_directory in
/etc/postgresql/8.1/main/postgresql.conf:
<snip>
data_directory = '/home/var/lib/postgresql/8.1/main'
<snip>
3. I copied /var/lib/postgresql to /home/var/lib/postgresql:
cp -rp /var/lib/postgresql /home/var/lib
4. Then, started the server:
/etc/init.d/postgresql-8.1 start
5. As you can see, it did not pick up the configuration change:
postgres 6197 0.9 0.1 19544 3544 ? S 11:38 0:00
/usr/lib/postgresql/8.1/bin/postmaster -D /var/lib/postgresql/8.1/main
-c config_file=/etc/postgresql/8.1/main/postgresql.conf
postgres 6199 0.0 0.0 19544 1048 ? S 11:38 0:00
postgres: writer process
postgres 6200 0.0 0.0 10324 972 ? S 11:38 0:00
postgres: stats buffer process
postgres 6201 0.0 0.0 9484 1156 ? S 11:38 0:00
postgres: stats collector process
6. Tried stopping the server, which failed:
db1:~# /etc/init.d/postgresql-8.1 stop
Stopping PostgreSQL 8.1 database server: main* Error: pid file is
invalid, please manually kill the stale server process.
failed!
7. I SIGHUP'ed the daemon, and removed the run pid, and restarted:
kill -1 6197
kill 6197
cat > /var/run/postgresql/8.1-main.pid
8. I tried restarting again. Got the same result as step 5.
I think this is a bug in the init scripts, or the functions it calls in
/usr/share/postgresql-common/init.d-functions. It should be calling
with '-D /home/var/lib/postgresql/8.1/main'. The change in the
postgresql.conf seems to be completely disregarded.
9. Here is the output of /var/log/postgresql/postgresql-8.1-main.log
during a startup.:
2007-06-19 11:20:09 EDT LOG: could not load root certificate file
"root.crt": No SSL error reported
2007-06-19 11:20:09 EDT DETAIL: Will not verify client certificates.
2007-06-19 11:20:09 EDT LOG: database system was shut down at
2007-06-19 11:15:45 EDT
2007-06-19 11:20:09 EDT LOG: checkpoint record is at 0/33A8A4
2007-06-19 11:20:09 EDT LOG: redo record is at 0/33A8A4; undo record is
at 0/0; shutdown TRUE
2007-06-19 11:20:09 EDT LOG: next transaction ID: 607; next OID: 10794
2007-06-19 11:20:09 EDT LOG: next MultiXactId: 1; next MultiXactOffset: 0
2007-06-19 11:20:09 EDT LOG: database system is ready
2007-06-19 11:20:09 EDT LOG: transaction ID wrap limit is 2147484146,
limited by database "postgres"
2007-06-19 11:20:09 EDT LOG: autovacuum: processing database "postgres"
2007-06-19 11:20:10 EDT LOG: incomplete startup packet
10. When I attempt to /etc/init.d/postgresql-8.1 stop, I simply get this
in the log:
2007-06-19 11:21:19 EDT LOG: incomplete startup packet
Please advise.
Ryan
--
Ryan Steele
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
