LinuxSA Mailing list archives

  From: Alan Kennington <akenning@topology.org>
  To  : Darryl Ross <dross@syc.asn.au>
  Date: Thu, 17 May 2001 16:12:23 +0930

Re: splitting a large text file into smaller files

On Thu, May 17, 2001 at 03:37:55PM +0930, Darryl Ross wrote:
> 
> I've just done a pg_dump of one of our databases, in order to clean it up a
> bit and I'm at the stage where I need to put the data back into the server.
> Unfortunately, the text file is 300K long and the buffer will only hold 20K.
> I've worked out that I can fit about 15 records into that buffer.


Darryl,

That sounds a bit odd to me.
This is a file that I often use for sending files from
one machine to another (from emu to tiger!):

akenning@tiger> wc *.sql
   7354  102411  545992 akenning.sql   

PostgreSQL has no problem with 7354 lines, being
about 546 (decimal) kBytes.

Is there some special reason why your file cannot be
fed back into PostgreSQL?

I use this command to re-insert the database:

    psql < akenning.sql

Are you using psql?

Cheers,
Alan Kennington.

-- 
LinuxSA WWW: http://www.linuxsa.org.au/  IRC: #linuxsa on irc.linux.org.au
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject