On Mon, Mar 19, 2001 at 10:26:54AM -0500, Andrew Perrin wrote:
> Running a locally-compiled postgresql 7.0.3, I'm still trying to get it
> to start up automatically at boot time. The trick is, of course, to get
> it to start as user postgres instead of root.
hiya. it's been a while since i've seen this mentioned on the
list but in case some of y'all'uns have forgotten (or never seen)
this -- there's a POTATO-FRIENDLY 7.0.3 POSTGRES available via
apt-get!
first, if you already have postgresql data, then
pg_dumpall > save.your.hide.sql
(you may need to munge (via text editor) the sql output from
pg_dumpall, as some new features are more strict on
representation & so forth.)
--
then upgrade via adding this to sources.list :
# /etc/apt/sources.list
# postgresql 7.0.3 DEBIAN POTATO-FRIENDLY
deb http://www.samfundet.no/~tfheen/debian potato main
now you can
apt-get update
apt-get install postgresql{,-dev,-doc,-pl,-client}
--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'
[EMAIL PROTECTED]
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
