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.

?


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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 debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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.
>
> ?
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.orgwith a subject
> of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

On 9/12/07, Jude DaShiell <jdashiel@shellworld.net> 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?
<erno> 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 debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

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 debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Hi,

2007/9/15, Chris Bannister <mockingbird@earthlight.co.nz>:
> 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/s...g-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 debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org