Le 11/11/2010 17:46, Vangelis Katsikaros a écrit : > On 11/11/2010 03:05 PM, Guillaume Lelarge wrote: >> >> You should better look at pgloader which will use COPY to put your data >> in your table and found the lines in error. Of course, it takes time to >> detect lines in error. But at least, all "good" lines will be in your >> table, and all "bad" lines will be in a file, so that you can modify >> them to inject later. >> >> > > Hi > > Thanks for the answer, indeed it solves the issue. > Great. > Now, I would like to ask a second question (sorry for using the same > thread :) > > I would like to create a specific database on a another location (not in > "data_directory = '/var/lib/postgresql/8.3/main'" ). I was wondering if > I have to run > initdb -D /other/path/ > > of if there is another way > To create another database in another location, you first need to create a tablespace, and then create a database in that tablespace. For example, in psql: CREATE TABLESPACE otherlocation LOCATION '/some/specific/directory'; CREATE DATABASE newdb TABLESPACE otherlocation; > (for example in mysql I can do the same thing by creating a symlink to > the other location inside "datadir = /var/lib/mysql" ) > Don't know MySQL, so can't say :) -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
