Re: How to get database schema without pg_dump?

From: Boban Acimovic <acim(at)mbl(dot)is>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: How to get database schema without pg_dump?
Date: 2001-12-12 10:13:43
Message-ID: 1008152023.26899.2.camel@acim.mbl.is
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

> So the characterization of the bug seems to be: regular expressions
> crash if you build with locale support but not multibyte support?
>
> Seems odd that we'd not have heard about that before. Can you build it
> that way again, adding --enable-debug this time, and provide a stack
> trace from the point of the crash?

This is a bit strange. Before few days I recreated all databases again
using LATIN1 locale and all of them were OK after. I could use all \d
commands and pg_dump worked correctly. The day after one database showed
the some problem again and then one more day after, another database has
the same problem. There is still one database (the biggest one) working
completely OK. Just to mention, I am doing vacuum every night on all
databases before I take backups.

When I try \d commands or pg_dump, backend crash completelly.

So, I haven't resolved this problem and I am currently installing gdb
5.1 and I will recompile Pg with --enable-debug. After I have logs, I
will post them here if someone can help me what to do.

Just to repeat, this is Solaris 8 on Sparc and PosgtreSQL 7.1.3.

Regards,
Boban Acimovic
www.mbl.is

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MR 2001-12-12 15:18:35 Re: how often should I run Vacuum
Previous Message Richard NAGY 2001-12-12 09:59:08 Re: Big problem about libpq.so.2.1, ldconfig and ldd

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2001-12-12 11:43:15 Re: Can't pg_dump
Previous Message Harry Yau 2001-12-12 08:48:48 About rserv