[orca-tech:01283] postgresqlのupgrade

["Katsuhiko Ito, MD" <katsuhiko.ito@xxxxxxxxx>]

もう１週間前くらいでしょうか，postgresqlがupgradeされましたが，upgrade後
日レセの事業所番号が消えてしまうケースがあるようです。

練習用のノート（事業所番号000000000000）などでの現象ですが，このため運用
機ではapt-get upgradeしていません。

運用機では問題ないでしょうか？

-- 
**********************************************************
伊東 克彦:Katsuhiko Ito, MD, PhD, FJSIM
宮前平内科クリニック:Miyamaedaira General Practice Clinic
TEL:044-860-4119, FAX:044-860-4199 (+81-44-860-4199)
mailto:katsuhiko.ito@xxxxxxxxx
http://www.miyamaedaira.com
http://homepage1.nifty.com/k-ito-md/
**********************************************************

# apt-get upgrade
Reading Package Lists... Done
Building Dependency Tree... Done
3 packages upgraded, 0 newly installed, 0 to remove and 0  not upgraded.
Need to get 1900kB of archives. After unpacking 237kB will be freed.
Do you want to continue? [Y/n]
Get:1 ftp://ftp.jp.debian.org woody-proposed-updates/main libpgsql2
7.2.1-2woody
5 [65.7kB]
Get:2 ftp://ftp.jp.debian.org woody-proposed-updates/main
postgresql-client 7.2.
1-2woody5 [281kB]
Get:3 ftp://ftp.jp.debian.org woody-proposed-updates/main postgresql
7.2.1-2wood
y5 [1554kB]
Fetched 1900kB in 17s (109kB/s)

(Reading database ... 37220 files and directories currently installed.)
Preparing to replace libpgsql2 7.2.1-2woody4 (using
.../libpgsql2_7.2.1-2woody5_
i386.deb) ...

Unpacking replacement libpgsql2 ...
Preparing to replace postgresql-client 7.2.1-2woody4 (using
.../postgresql-clien
t_7.2.1-2woody5_i386.deb) ...

Unpacking replacement postgresql-client ...
Preparing to replace postgresql 7.2.1-2woody4 (using
.../postgresql_7.2.1-2woody
5_i386.deb) ...
Stopping PostgreSQL database: postmaster
Stopped /usr/lib/postgresql/bin/postmaster (pid 612 614 616 1195).
.

Found an existing database directory at /var/lib/postgres/data
The installed database is of the same version as the one
to be installed. You do not need to dump your database
for reloading.

Unpacking replacement postgresql ...
Setting up libpgsql2 (7.2.1-2woody5) ...

Setting up postgresql-client (7.2.1-2woody5) ...

The file /etc/postgresql/postgresql.env provides the normal set-up for
an ordinary user running PostgreSQL. It is automatically read by the
wrapper script for PostgreSQL user commands in postgresql-client.


Setting up postgresql (7.2.1-2woody5) ...
Restarting PostgreSQL database: postmaster
No /usr/lib/postgresql/bin/postmaster found running; none killed.
Starting PostgreSQL postmaster.
postmaster successfully started
.
Enabling the PL procedural language in all PostgreSQL databases...
plpgsql is already enabled in orca
plpgsql is already enabled in template1