: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres locks table schema?
"Stas Oskin" <[EMAIL PROTECTED]> writes:
> When running SQL scripts, which change the tables' schema, we sometimes
> experience a lock of these tables' schema. The lock occurs on the f
On Wed, 2005-09-21 at 12:51, Stas Oskin wrote:
> Hi.
>
>
>
> When running SQL scripts, which change the tables' schema, we
> sometimes experience a lock of these tables' schema. The lock occurs
> on the first command of the script, on the first modified table. When
> this occurs, no further sch
"Stas Oskin" <[EMAIL PROTECTED]> writes:
> When running SQL scripts, which change the tables' schema, we sometimes
> experience a lock of these tables' schema. The lock occurs on the first
> command of the script, on the first modified table. When this occurs, no
> further schema modification for t
Tom Lane wrote:
> Jeff Davis <[EMAIL PROTECTED]> writes:
>
>> Basically, psql would sit there trying to connect, meanwhile all the
>> attempted connections wouldn't die.
>
>
> More details please? What do you mean exactly by the above statements?
>
>> I had to "kill -9" all the
>> postgres
Ok, I think I know what happened, kind of..
One of my users' databases was currupt. I actually had to delete the
entire base/ folder. Then I went in and drop/created the DB
again and it seems to work fine.
Is there any was to know how this happened? I have a .tar of the currupt
DB if someone
