New answers tagged

-1 votes

Parallel pg_restore unsupported

I had the same issue with restoring a database dump but on Digital Ocean. The issue is the -jobs 4 flag. Which in your case i suspect to be -j 4. Remove this so that it does this in a single thread. ...
Youzef's user avatar
  • 99
0 votes

Change existing column in PG to auto-incremental primary key

I'm posting this because since PG10 serial syntax has been replaced by generated always|default as identity to make it SQL Standard compliant, so it changes things a bit. Now you don't have to define ...
EAmez's user avatar
  • 145
0 votes

Is it possible to obtain number of prepared statements a connection holds?

You can use pg_prepared_statements view to show all the prepared statements in the current session. *Prepared statements are deleted after logout: SELECT * FROM pg_prepared_statements; And, you can ...
Super Kai - Kazuya Ito's user avatar

Top 50 recent answers are included