Re: [SQL] 1 milion data insertion
On Fri, Jul 26, 2002 at 03:34:12PM -0300, Elielson Fontanezi wrote: > Hi fellows! > > I have tried to insert 1.000.000 of record to the following table; > > -- > zakal=# \d teste; > codigo | bigint | not null > nome | character varying(100) | > -- > > and I got these errors: > > -- > zakal$ psql -c "copy teste from 'teste.dat' using delimeters '|'" > ERROR: parser: parse error at or near "delimeters" > ERROR: parser: parse error at or near "delimeters" > zakal$ psql -c "copy teste from 'teste.dat' using delimiters '|'" > ERROR: COPY command, running in backend with effective uid 504, could not > open > file 'teste.dat' for reading. Errno = No such file or directory (2). > ERROR: COPY command, running in backend with effective uid 504, could not > open > file 'teste.dat' for reading. Errno = No such file or directory (2). > zakal$ pwd > /home/zakal/tmp > zakal$ psql -c "copy teste from '`pwd`/teste.dat' using delimiters '|'" > DEBUG: copy: line 27536, XLogWrite: new log file created - consider > increasing > WAL_FILES > DEBUG: copy: line 93146, XLogWrite: new log file created - consider > increasing > WAL_FILES > DEBUG: recycled transaction log file > > > ERROR: copy: line 164723, Bad int8 external representation "16722" > ERROR: copy: line 164723, Bad int8 external representation "16722" > zakal$ > zakal$ > zakal$ DEBUG: recycled transaction log file 0001 > -- > > the log has overflowed. > > Ok, this was a test. I'd like to know what would be happen. > But, from you, great PostGres DBA's, what is the best way to > insert a large number of data? > Is there a way to turn off the log? > Is there a way to commit each 100 records? > > regards, in relativly small chuncks, do 100 10,000 record transactions and you should be fine. marc > > .. > A Question... > Since before your sun burned hot in space and before your race was born, I > have awaited a question. > > Elielson Fontanezi > DBA Technical Support - PRODAM > +55 11 5080 9493 > > > > ---(end of broadcast)--- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] RES: [GENERAL] set DateStyle to 'SQL'
On Fri, Jul 26, 2002 at 01:56:16PM -0300, Elielson Fontanezi wrote: > The environment variables PGHOST and PGPORT specify to client applications > the host and port of the database server, overriding the compiled-in > defaults. If you are going to run client applications remotely then it is > convenient if every user that plans to use the database sets PGHOST. This is > not required, however: the settings can be communicated via command line > options to most client programs. > --- > > But... likely there are much more variables rather than PGDATA, > PGHOST and PGPORT. > Where can I find them? Perhaps you're looking for http://www.postgresql.org/idocs/index.php?runtime-config.html Please trim your replies to the list. -Roberto -- +| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer A .45 beats a royal flush EVERY TIME ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [SQL] Using Tables from another database.
* Reinoud van Leeuwen <[EMAIL PROTECTED]> [020726 08:05]: > On Thu, 25 Jul 2002 17:02:44 + (UTC), [EMAIL PROTECTED] > (Rogério Baldini das Neves) wrote: > >create view view_test as select * from mydb.mytable; > > This is possible in Sybase or Microsoft SQL server, not in Postgresql > (AFAIK) Yet. It's on the TODO list. -- D'Arcy J.M. Cain| Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] set DateStyle to 'SQL'
Hi folks! There are a buch of varibles like DateStyle. I am interested to set them all in script shell. I've tried in postgresql.conf, but I could not. I've tried in shell environment, but it did not work. So, how can I do that? .. A Question... Since before your sun burned hot in space and before your race was born, I have awaited a question. Elielson Fontanezi DBA Technical Support - PRODAM +55 11 5080 9493 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[SQL] Numeric Style format
Hi! Is there any way to format data type NUMERIC values as I can do with data type DATE using DateStyle. For example, I want to type numeric values typing: "1.000,23" rather than "1,000.23". regards, .. A Question... Since before your sun burned hot in space and before your race was born, I have awaited a question. Elielson Fontanezi DBA Technical Support - PRODAM +55 11 5080 9493 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[SQL] RES: [GENERAL] set DateStyle to 'SQL'
Hi friends! Maybe I have not been clear. See, there are varibles like PGPORT, PG_HBA_SAMPLE, POSTGRES_BKI, POSTGRESQL_CONF_SAMPLE and much more. Where ca I find related information to them? and list of all them? my regards, E.F.:> -Mensagem original- E.F.:> De: Elielson Fontanezi [mailto:[EMAIL PROTECTED]] E.F.:> Enviada em: sexta-feira, 26 de julho de 2002 10:28 E.F.:> Para: pgsql-general E.F.:> Cc: pgsql-sql E.F.:> Assunto: [GENERAL] set DateStyle to 'SQL' E.F.:> E.F.:> E.F.:> Hi folks! E.F.:> E.F.:> There are a buch of varibles like DateStyle. I am E.F.:> interested to set E.F.:> them E.F.:> all in script shell. E.F.:> I've tried in postgresql.conf, but I could not. E.F.:> I've tried in shell environment, but it did not work. E.F.:> E.F.:> So, how can I do that? E.F.:> ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
