Re: postgresql help
Hi, 2007/9/15, Chris Bannister <[EMAIL PROTECTED]>: > On Mon, Sep 10, 2007 at 08:36:59PM -0400, Tom Allison wrote: > > But somewhere I screwed up my postgresql-8.2 database installation. > > I meant to set up the data directory on the RAID disk array > > Unfortunately I deleted the /var/lib/postgresql/ directory and can't or > > don't know what to do to fix it. > > You mean you have lost your data? If you are just talking about creating an empty cluster in a new location The debian wrappers for this are described in: pg_createcluster, pg_ctlcluster, pg_dropcluster, pg_lsclusters, pg_maintenance if i remember correctly. If you want to stay with postgres builtin methods have a read at: http://www.postgresql.org/docs/8.2/static/creating-cluster.html > Have you a recent backup? if you really lost your data by accidentally having deleted the files a recent backup is your only chance of getting back to where you were hth martin -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: postgresql help
On Mon, Sep 10, 2007 at 08:36:59PM -0400, Tom Allison wrote: > I'm at a road block... > > I was reinstalling my hard drives to put in a RAID1 array. > The RAID/LVM stuff works 100%. > > But somewhere I screwed up my postgresql-8.2 database installation. > I meant to set up the data directory on the RAID disk array > Unfortunately I deleted the /var/lib/postgresql/ directory and can't or > don't know what to do to fix it. You mean you have lost your data? Have you a recent backup? -- Chris. == -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: postgresql help
On 9/12/07, Jude DaShiell <[EMAIL PROTECTED]> wrote: > When you do an uninstall with purge, your original packages are still in > /var/cache/apt/archives. I had a situation with timidity that was similar > though I had lost one of timidity's configuration files and reinstalling > using packages already on the hard drive did not repair the situation. I > ended up deleting from /var/cache/spt/archives the timidity files after an > uninstall with purge had been done then did an aptitude install on > timidity and that did repair the situation. apt-get clean should do this for you. Adrian -- 24x7x365 != 24x7x52 Stupid or bad maths? hm. I've lost a machine.. literally _lost_. it responds to ping, it works completely, I just can't figure out where in my apartment it is. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: postgresql help
When you do an uninstall with purge, your original packages are still in /var/cache/apt/archives. I had a situation with timidity that was similar though I had lost one of timidity's configuration files and reinstalling using packages already on the hard drive did not repair the situation. I ended up deleting from /var/cache/spt/archives the timidity files after an uninstall with purge had been done then did an aptitude install on timidity and that did repair the situation. On Mon, 10 Sep 2007, Tom Allison wrote: I'm at a road block... I was reinstalling my hard drives to put in a RAID1 array. The RAID/LVM stuff works 100%. But somewhere I screwed up my postgresql-8.2 database installation. I meant to set up the data directory on the RAID disk array Unfortunately I deleted the /var/lib/postgresql/ directory and can't or don't know what to do to fix it. No big deal, nothing invested, so I did a uninstall/purge on postgresql-8.2. I reinstalled the database using aptitude (postgresql-8.2, postgres-client-8.2, libpq5) thinking that this would fix everything. Nothing is happening. No logs created to indicate if it works or not. No directory created to show where the data directory is. Nothing. I'm just staring blankly at this. I did a uninstall + purge and no errors reported. I do a reinstall and NOTHING. I've never experienced anything this blank before. help? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: postgresql help
On 2007-09-10T20:36:59-0400, Tom Allison wrote: > But somewhere I screwed up my postgresql-8.2 database installation. > I meant to set up the data directory on the RAID disk array > Unfortunately I deleted the /var/lib/postgresql/ directory and can't > or don't know what to do to fix it. Do you have any of postgres processes running (ps aux|grep postgres)? You may want to kill those off after uninstall the postgres packages. Did you purge & install postgresql-common? /Allan -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]