Lukasz Brodziak wrote:
> I have two DBs from the same user. When I run a query: SELECT
> wer_sys||'.'||wer_int||'.'||wer_wew FROM ver WHERE code = '1243'
> on a boken DB I get an error: ERROR: array value must start with
> "{" or dimension information but when I try to run the query on a
> "he
Joost Kraaijeveld wrote:
>> I thought you said that pg_dropcluster was what was
>> run? When you say the directories are "untouched" does that mean
>> that no files have been deleted from them?
> Apart from the postgres and template* databases...
Ah, if the directories containing the data had
On Wed, 2011-09-07 at 10:08 -0500, Kevin Grittner wrote:
> In any event, if the files are recovered to their original
> locations, the database should start.
I think that he lost the postgres database in the proces, which seems to
hold the information for every database in the cluster.
> > Of c
"Gnanakumar" wrote:
> We're using PostgreSQL v8.2.3.
There are probably hundreds of bug fixes between 8.2.3 and the
current 8.2 release, which is 8.2.21.
http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.2/static/release.html
On top of that, 8.2 is so old that
On Tue, Sep 6, 2011 at 3:06 PM, MirrorX wrote:
> hello to all
>
> i am stuck in the following situation. i have a table which is 500GB. due to
> some deleted rows the actual size is about 350-400GB and i would like to
> reclaim that disk space since from now on this table will remain at this
> lev
Joost Kraaijeveld wrote:
> During an upgrade of by customer he managed to drop the original
> cluster as the first step. As soon as he saw his error he broke
> off the pg_dropcluster by ctrl-c.
pg_dropcluster is not something provided by the PostgreSQL
community; it seems to be part of the Deb
An addition to the previous post:
In an attempt to repair the damage he reinstalled Postgresql 9.0 and now
has a running 9.0 with ~ 10 database in the ../9.0/base directory
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-36084
Hi,
During an upgrade of by customer he managed to drop the original cluster
as the first step. As soon as he saw his error he broke off the
pg_dropcluster by ctrl-c. Of course he has no useful backups, But it
appears that the directories of the database he wants to restore are
still on disk and u
