On 06/10/2008 14:03, Alain Roger wrote: > this is basically what i use but it does not work. > > pg_restore -C -d sewe survey.tar -U postgres Just a guess, since I haven't used pg_restore - a quick look at the docs suggests that the filename should come *last* on the command line, so try that. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------