[ADMIN] pg_dump error

2000-04-16 Thread Joe Conway
Hello, I am getting the following error when trying to use pg_dump: *** pg_dump cymi > cymi.2000_04_16.dmp FATAL 1: Memory exhausted in AllocSetAlloc() PQendcopy: resetting connection SQL query to dump the contents of Table 'cymi_de

Re: [ADMIN] Database conversion

2000-04-16 Thread Chris Carbaugh
Check out the ODBC driver on the PG site. Quite simple really. Just load the driver on your Win Box, and create the DSN. Now all you have to do is open Access, and export your tables via ODBC. I have only done this a few times with rather simple databases, but haven't had any troubles. It cre

Re: [ADMIN] Database conversion

2000-04-16 Thread brad
I have had problems with the pg_dump command, though, when the tables have been wide (many columns with long text items in them) and deep (many rows). The pg_dump utility reloads the data from the stdin, using a pipe. This doesn't work too well (i.e. no data gets loaded) for these tables, but is

Re: [ADMIN] Database conversion

2000-04-16 Thread Max Pyziur
Steve Murphy wrote: > > Hi, > > Does anyone know of any conversion programs that will either convert an > MS Access database file to a Postresql database or from a Filemaker Pro > database file to a Postresql database for the Red Hat Linux OS? > > Any help or educated guesses of where to start

[ADMIN] initialisation problem

2000-04-16 Thread julien piaser
After compiling and installing Postgresql7.0beta3 successfully as described in the INSTALL file, I created a postgres profile, and I updated my PGDATA and PGLIB local variables. I can manually start postmaster, and postgresql works really well. I executed the /usr/src/postgresql-7.0beta3/contrib