Leaderboard

I did import via command line. No idea why the UI wouldn't see the server, but phppgadmin has a limit of like 50MB anyway so even if it did, this particular file won't import through it due to size.

So, 2 hours on, this database is both too large for our systems and for the wrong version of postgres (it's for 9.x, we have 8.x on Johnny). This will not run here. It's still finished the import on the schema file, but its almost certainly not going to work correctly. I won't bother to attempt the 400MB of data as I'll only run you out of disk space and whatever this DB goes to is likely not going to work anyway due to the version differences...a significant number of commands have failed at this point due to being for the wrong version. If you want to go ahead, let me know, otherwise you can just drop the database.

Looks like it's got a bunch of syntax issues psql:cidade_schema.sql:201697: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2606551314 OWNER TO walter21_cidade; ^ lo_create ------------ 2608066841 (1 row) psql:cidade_schema.sql:201706: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2608066841 OWNER TO walter21_cidade; ^ lo_create ------------ 2608583171 (1 row) psql:cidade_schema.sql:201715: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2608583171 OWNER TO walter21_cidade; ^ lo_create ------------ 2608589391 (1 row) psql:cidade_schema.sql:201724: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2608589391 OWNER TO walter21_cidade; ^ lo_create ------------ 2775496897 (1 row) psql:cidade_schema.sql:201733: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 2775496897 OWNER TO walter21_cidade; ^ lo_create ------------ 3611089473 (1 row) psql:cidade_schema.sql:201742: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 3611089473 OWNER TO walter21_cidade; ^ lo_create ----------- 489583744 (1 row) psql:cidade_schema.sql:201751: ERROR: syntax error at or near "LARGE" LINE 1: ALTER LARGE OBJECT 489583744 OWNER TO walter21_cidade; ^ SET What version postgres was this DB for anyway? If it's meant for 9.x, no wonder it's been spewing errors. Johnny has 8.x...ALTER LARGE OBJECT seems to be a 9.x command. If this is the case, this database simply won't run on Johnny properly.

I'm not surprised it wouldn't import for you simply due to its size. Those database files are huge. I copied and fixed the SET OWNER commands on the schema file so it assigns the tables and schemas to a user that exists (you), then started it and its still running. I'm not even going to attempt the demo data right now... Also, it seems happy right now, but there were tons of errors in the beginning, so if it doesn't work we'll need to drop it and try again. I'll let you know when it's done. EDIT: I think you've won the award for most tables in a single database on our server And it's still not done...