Dear Experts,
Yesterday I had a disk-nearly-full problem, and decided to try to resolve
it by moving one large table to a spare disk in a new tablespace:
=# create tablespace tempspace location "/db_temp";
=# alter table requests set tablespace tempspace;
That didn't work; I think disk space ha
Hi everyone,
We are in the process of upgrading from PostgreSQL 9.6 to 13. When our
database gets created in our regression tests, we run some unit tests
first. We see one of those tests hang.
It seems the client is waiting on more data to arrive from the
PostgreSQL server. A thread dump sho
On Fri, Jul 09, 2021 at 01:16:16PM +1000, rob stone wrote:
> Hello,
>
> I am curious.
>
> NVL, DECODE and SELECT FROM dual are Oracle methods and these appear in
> your code.
>
> How did you make these work in Postgres?
>
> Cheers,
> Rob
Hi Rob,
At a guess, they are using the Orafce PostgreS
Hello,
I'm working with an RDS instance running 12 that has an old subscription
that I can't seem to drop.
The logs show this, repeating every 5 seconds or so.
2021-07-09 16:08:07 UTC::@:[1637]:LOG: logical replication apply worker
for subscription "metro" has started
2021-07-09 16:08:07 UTC
Hi,
I have had a ASP Website working for the 5 years and have had no problems
until at the weekend I replace my database server with a newer one.
Database server (old): Postgres 9.4 64bit
Database server (new): Postgres 12.6 64bit
The Website connect to PostgreSQL 9.4 64bit with psqlodbc_10_0
