Server Disconnected Error: python with postgresql

Asked Oct 27 '21 at 01:22

Active Oct 27 '21 at 01:22

Viewed 72 times

I'm trying to upload some heavy data in postgresql from dask python but it's giving the following error: Server Disconnected. Can anyone help me?

code:

base_SP.to_sql('SIPNI_SP2', 'postgresql://postgres:postgres@localhost:5432/vacinacao',if_exists='replace', index = False, chunksize=1000, dtype = sqlalchemy.VARCHAR , method='multi',compute=True, parallel=False)

asked Oct 27 '21 at 01:22

Yasmin Amaro

1

Trying to remove the obvious: is the Postgres server running? – mechanical_meat Oct 27 '21 at 01:30
yes, the server is running. I can import smaller datasets – Yasmin Amaro Oct 27 '21 at 16:00
Oh, maybe there's a timeout which needs to be set to a higher value. Try running `show statement_timeout;` from psql and see if that's some low value. If it's set to zero there's no limit, and this is not the issue. – mechanical_meat Oct 27 '21 at 16:26

Server Disconnected Error: python with postgresql

0 Answers0