| From: | Bill Teluk <bill(dot)teluk(at)team(dot)telstra(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: psql causing a error |
| Date: | 2011-03-22 03:56:27 |
| Message-ID: | 1300766187565-4248901.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Raghu and thanks!,
This fix helped me too.
My installation is an OpenSCG PostgreSQL 9.0.3 build with PostGIS 1.5.2
installed; and as per Sandra - the installation worked fine for several days
then failed - I got mine going again the first time by multiple restarts and
some port config changes, but the second time I looked further and found
this post. Each time I had a failure on mine, it was triggered by loading
an SQL script via "psql -f" generated by the shp2pgsql utility that ships
with PostGIS v1.5.2 - the script looked fine to me though (and deleting the
tables generated by it failed to restore operation.) Also, pgAdmin
(v1.12.2) seemed to work OK where psql wouldn't.
Regards, Bill.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-causing-a-error-tp3410159p4248901.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicholson, Brad (Toronto, ON, CA) | 2011-03-22 13:57:48 | Re: pg_stat_all_tables column value reseting problem. |
| Previous Message | Paul Gross | 2011-03-21 16:08:35 | Restarting recovery mode with pg_standby after failure |