You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to load data into 4 different foreign tables. Each COPY runs as expected, but whenever I try to parallelize the operation, i.e. run 4 different COPY instructions at the same time, the server crashes with the following message:
FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Upon restarting the connection, every time I try to execute a singleCOPY statement, Postgres throws the same error, rendering the tables useless. Only way to have them populated is to drop them, create them again and execute COPY on each table, individually.
Is there a way to do this process in parallel? Each table has a populating process of their own, there are no concurrent writes to the same table.
The command I run to populate the tables is:
COPY <table> FROM '<path>' WITH CSV;
The text was updated successfully, but these errors were encountered:
I am trying to load data into 4 different foreign tables. Each
COPY
runs as expected, but whenever I try to parallelize the operation, i.e. run 4 differentCOPY
instructions at the same time, the server crashes with the following message:Upon restarting the connection, every time I try to execute a single
COPY
statement, Postgres throws the same error, rendering the tables useless. Only way to have them populated is to drop them, create them again and executeCOPY
on each table, individually.Is there a way to do this process in parallel? Each table has a populating process of their own, there are no concurrent writes to the same table.
The command I run to populate the tables is:
COPY <table> FROM '<path>' WITH CSV;
The text was updated successfully, but these errors were encountered: