Simon Riggs writes:
> On Thu, Jun 16, 2011 at 7:44 AM, bakkiya wrote:
>> Space,permission are not an issue.
> Then presumably you have your stats_temp_directory parameter set to a
> path where that is not true.
But the error message is showing the specific file path that the stats
collector tri
Hi out there,
i migrated some month ago our databases from 8.4 to 9.0 and now getting
errors like:
2011-06-12 06:25:33 CEST ERROR: could not access status of transaction
59768467
2011-06-12 06:25:33 CEST DETAIL: Could not open file "pg_clog/0038": No
such file or directory.
2011-06-12 06:25:33
Am Donnerstag, den 16.06.2011, 14:21 +0200 schrieb Bernhard Schrader:
> Hi out there,
>
> i migrated some month ago our databases from 8.4 to 9.0 and now getting
> errors like:
>
> 2011-06-12 06:25:33 CEST ERROR: could not access status of transaction
> 59768467
> 2011-06-12 06:25:33 CEST DETAIL
Hi,
i'm searching for a solution for changing the type of a column, e.g. from
varchar(128) to varchar(512), without an ACCESS EXCLUSIVE lock. The issue is
that the relation is nearly 100 million rows big and in our environment
every second of downtime is very bad.
In my current setup a slave datab
Hi,
i'm searching for a solution for changing the type of a column, e.g. from
varchar(128) to varchar(512), without an ACCESS EXCLUSIVE lock. The issue is
that the relation is nearly 100 million rows big and in our environment
every second of downtime is very bad.
In my current setup a slave datab
Andreas Berger <4postg...@gmail.com> writes:
> i'm searching for a solution for changing the type of a column, e.g. from
> varchar(128) to varchar(512), without an ACCESS EXCLUSIVE lock.
That specific case (increasing the max length of a varchar column) could
be handled by hacking the pg_attribute
On 16 Jun 2011, at 18:30, Pratheeban Jebasingh Tharmaraj wrote:
> Hi Team,
>
> I am trying to add column to the table that's hanging.
>
> alter table hr_firms add column_name biginit;
^^
typo?
> This is the lock
I have set stats_temp_directory to postgresql/data/pg_stat_tmp, but still
this message is coming and also created pgstat.tmp file in that location
manually, but this file is getting removed automatically in few minutes.
postgresql/data/pg_stat_tmp> touch pgstat.tmp
postgresql/data/pg_stat_tmp> l
Hi Team,
I am trying to add column to the table that's hanging.
alter table hr_firms add column_name biginit;
This is the lock I see in the db
relation | 564709 | 586888 | | ||
| | | | 1/8| 1871 |
AccessExclusiveLock |
