Thread: Fedora 16 note...
I upgraded to Fedora 16 yesterday… I thought I might have lost my 12 year old db when the system came up and I noticed the 9.1 had overwrote the old binaries. Then I read about pg_upgrade stuff and it worked! I found that postgresql would not start at boot time until I did: systemctl enable postgresql.service Jerry
On 11/10/2011 11:10 PM, Jerry Levan wrote: > I upgraded to Fedora 16 yesterday… > > I thought I might have lost my 12 year old db when the system came up > and I noticed the 9.1 had overwrote the old binaries. ... of course, you keep regular backups so you weren't too worried anyway.... right? > Then I read about pg_upgrade stuff and it worked! Good to hear. I tend to dump and reload between versions as I have fairly small data, but it's good to hear people getting successful use out of pg_upgrade. > I found that postgresql would not start at boot time until > I did: > > systemctl enable postgresql.service That's Fedora policy: don't start a service unless the user asks for it to be started. -- Craig Ringer
On Nov 10, 2011, at 9:56 PM, Craig Ringer wrote: > On 11/10/2011 11:10 PM, Jerry Levan wrote: >> I upgraded to Fedora 16 yesterday… >> >> I thought I might have lost my 12 year old db when the system came up >> and I noticed the 9.1 had overwrote the old binaries. > > ... of course, you keep regular backups so you weren't too worried anyway.... right? > Not that I am paranoid or anything but I keep manually maintained clones on three other machines that are backed up via time machine to my NAS and I superduper the macs to separate disks. I also semi-periodically rsync many directories on the Fedora box to a separate disk. Dblink makes the manually cloning of the tables an easy task. I have written a bunch of tools to access postgresql, sorta like a PgAdmin light ( http://homepage.mac.com/levanj ) >> Then I read about pg_upgrade stuff and it worked! > > Good to hear. I tend to dump and reload between versions as I have fairly small data, but it's good to hear people gettingsuccessful use out of pg_upgrade. > >> I found that postgresql would not start at boot time until >> I did: >> >> systemctl enable postgresql.service > > That's Fedora policy: don't start a service unless the user asks for it to be started. This is the first time I have had to manually enable a service like postgresql and httpd since Fedora 4. I guess this is mostly from the systemd take over... > > -- > Craig Ringer
Jerry Levan <jerry.levan@gmail.com> writes: > On Nov 10, 2011, at 9:56 PM, Craig Ringer wrote: >> On 11/10/2011 11:10 PM, Jerry Levan wrote: >>> I found that postgresql would not start at boot time until >>> I did: >>> systemctl enable postgresql.service >> That's Fedora policy: don't start a service unless the user asks for it to be started. > This is the first time I have had to manually enable a service like postgresql and httpd > since Fedora 4. I guess this is mostly from the systemd take over... It's exactly from the systemd takeover. Traditionally a system upgrade would preserve your sysv "chkconfig" settings for which services to autostart, but there is a specific policy in place to not do that when a service is transitioned to systemd. The reasoning was that in many cases the configuration mechanisms are changing at the same time (for instance, postgresql no longer pays attention to /etc/sysconfig/) and autostarting a possibly-now-misconfigured daemon seemed like a bad idea. regards, tom lane