[postgis-users] big tables

[Chris G. Nicholas]

I 'm pretty sure its running out of: /data/postgres/gextest; (that is the directory listing below) which has some 180+ gigs left of space...

I start it up with: 

/usr/local/pgsql/bin/pg_ctl start -D /data/postgres/gextest -l /var/log/postgres/gextest -o -i

thanks for looking at this -
Chris

-----Original Message-----
From:	jrom [mailto:jga at scot.cnes.fr]
Sent:	Mon 6/30/2003 9:15 AM
To:	Chris G. Nicholas
Cc:	
Subject:	Re: [postgis-users] big tables

On Mon, 2003-06-30 at 17:58, Chris G. Nicholas wrote:

> hmmm - built/installed the latest/greatest Postgres/postgis-cvs sources with the "--enable-largefiles" flag, and am trying to load a few million rows into a fairly healthy box:
> 
> #more /etc/fstab
> LABEL=/                 /                       ext3    defaults        1 1
> none                    /dev/pts                devpts  gid=5,mode=620  0 0
> LABEL=/extra            /extra                  ext3    defaults        1 2
> none                    /proc                   proc    defaults        0 0
> none                    /dev/shm                tmpfs   defaults        0 0
> /dev/hda5               swap                    swap    defaults        0 0
> /dev/hda8               swap                    swap    defaults        0 0
> /dev/sda1               /data                   ext2    defaults        1 3
> /dev/hda2               /extra2                 ext2    defaults        1 3
> #
> #
> boss:/big2              /big2                   nfs     defaults        0 0
> 
> 
> #uname -a
> Linux pogo 2.4.20-8smp #1 SMP Thu Mar 13 17:45:54 EST 2003 i686 i686 i386 GNU/Linux
> 
> #df -k
> Filesystem           1K-blocks      Used Available Use% Mounted on
> /dev/hda1              6048320   3250992   2490088  57% /
> /dev/hda6              4411616     32828   4154684   1% /extra
> none                   1032252         0   1032252   0% /dev/shm
> /dev/sda1            481590296 268914636 188212284  59% /data
> /dev/hda2             70557084   2220916  64752068   4% /extra2
> boss:/big2           279914496 205316700  71798652  75% /big2

Hi,

Where did you install postgresql ?
Regarding your disk partionning, i think that your postgresql install is
somwhere on /dev/hda1 (perhaps on /var/lib/pgsql or /usr/local/pgsql ?)
You've got about 2Go left on /dev/hda1 but perhaps it's not enough.
You should move the ./base directory from postgresql to /dev/sda1 device
and make a symbolic link on it (so you do not have to change the install
path of postgresql). To be more clear, assuming ./base directory of
postgresql is on /var/lib/pgsql, do :

	mv /var/lib/pgsql/base  /data/base
	ln -s /data/base /var/lib/pgsql

And try again.

Regards 

Jerome