Re: Possible bug in postgresql-7.1.3-1PGDG

From: "John Fabiani" <jfabiani(at)yolo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible bug in postgresql-7.1.3-1PGDG
Date: 2001-10-19 15:38:29
Message-ID: 9qphbn$1iqd$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I don't think you have to start from scratch. Fair warning "I'm a newbie".
Since you don't care about the old data I'd just create a new location
setup. "initdb -D /usr/pgsql/data" I believe this create a new setup for
your data. Of course you will have to change the start up location in the
start up scripts. If you are using 7.1 RH I think the start up script is in
"/etc/rc.d/init.d"
I hope this helps.
John
"Rich Shepard" <rshepard(at)appl-ecosys(dot)com> wrote in message
news:Pine(dot)LNX(dot)4(dot)33(dot)0110190702590(dot)13239-100000(at)salmo(dot)appl-ecosys(dot)com(dot)(dot)(dot)
> On Fri, 19 Oct 2001, Brett W. McCoy wrote:
>
> > There should be! Are you sure you are using 7.1.3? It sounds like the
> > data directory didn't get upgraded properly.
>
> Brett,
>
> I am no longer sure what's installed. When I look at
> /var/lib/pgsql/data/base/PG_VERSION I see '7.1.2'. But, I ran 'rpm -Uvh
...'
> for the 7.1.3 upgrade (rather than a freshen).
>
> No data worth saving now, I've been consumed with too many other
projects.
> But, I have both business and scientific databases I need to build so I
want
> to get 7.1.3 correctly installed and working; I'll keep current after
that.
>
> Should I move configuration files (such as pg_hba.conf) to a safe area,
> then manually delete all references to postgres that locate and find
reveal,
> before starting from scratch?
>
> Right now I'm looking to get a working installation of 7.1.3 so I can
> start developing these applications.
>
> Thanks,
>
> Rich
>
> Dr. Richard B. Shepard, President
>
> Applied Ecosystem Services, Inc. (TM)
> 2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
> + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) |
rshepard(at)appl-ecosys(dot)com
> http://www.appl-ecosys.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-10-19 15:52:42 Re: Possible bug in postgresql-7.1.3-1PGDG
Previous Message John Fabiani 2001-10-19 15:31:22 Re: Is the postmaster running (with -i) at 'localhost