Re: psql -f backup.out || file too big - SOLVED

I solved my problem, it was quite easy, and the error was cause by a
limitation of the psql proggie.

the solution was:

psql < backup.out

instead of

psql -f backup.out

according to the man pages, using "psql -f" or "psql <" would give us the
same result, but the -f parameter will give us "better messages"...

what that psql -f limit documented somewhere?

thanx all for your help!

Jorge S.

On Friday 09 November 2001 08:52 pm, Jorge Sarmiento wrote:
> Hello everybody!
>
> I am trying to restore a 2.5 Gb. backup file made using pg_dumpall, and I
> get the "file too big" error message from postgres
>
> what can I do to solve this? is this a bug? I have 18 Gb. free disk space,
> a two PIII processor machine with 1 Gb. ram, running Red Hat 7.1 with
> Postgresql 7.1.3 (installed from official rpms)
>
> thank in advance for your help!
>
> greetings!
>
> Jorge Sarmiento
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)