Re: [ADMIN] [GENERAL] Dump and Restore

I am using pg_dump. It means that I can't restore to a different name database?? Eduardo S. Fontanetti --- Paul Thomas <[EMAIL PROTECTED]> escreveu: > > On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: > > How can I do a test if my dumping is really > working, I &

[ADMIN] Dump and Restore

test if my backup is working fine, and will help if I need sometime? Thanks for all of you! Eduardo S. Fontanetti ___ Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade! http://br.acesso

Re: [ADMIN] Conversion de MDB a Postgres

Isto acontece sem erro nenhum? Qual a versão do Access? E qual o driver ODBC que está utilizando para o Postgres? Eduardo S. Fontanetti --- Christian Hache <[EMAIL PROTECTED]> escreveu: > Lo he hecho, pero la parecer me pase la estrcutura > sin lo datos, no se en > que me esto

[ADMIN] Backup

I have a question. I am getting trouble to dump my database with LO (Large Object), but exactly at restoring. Then I ask: If I just copy the data directory from pgsql directory, I can restore the databases just copying this directory back from a backup? Thanks Eduardo

Re: [ADMIN] Conversion de MDB a Postgres

Vou responder em português, pois não conheço muito de espanhol. Tive o mesmo problema com o meu banco de dados, que era em Access 2000. Para exportar, eu utilizei o próprio Access, usando um driver ODBC. Selecionando a tabela, clique com o botão direito do mouse sobre o nome da tabela, e selecione

[ADMIN] pg_dumpall with lo

I am trying to use pg_dumpall to backup my database, but it is not copying the large objects to the dump file. I tried to use the --blobs option, but it just work with pg_dump. Does somebody could help me? Thanks a lot! Eduardo

Re: [ADMIN] Insert binary data on postgre

07:43, Eduardo S. Fontanetti > wrote: > > I forgot a little, or better, a big detail, to do > this > > translating from binary to ANSI of a file with > 100Kb, > > it will return something like 50 bytes, and > this > > process is very, very and very slow. T

Re: [ADMIN] Insert binary data on postgre

put a backslash before the ' on the string, but it hadn't worked, I think it don't interprets the character like postgres. Somebody knows how to solve it? How to identify the character exactly like the postgres? Thanks Eduardo --- "Eduardo S. Fontanetti" <[EMAIL PROTECT

Re: [ADMIN] Insert binary data on postgre

--- mike g <[EMAIL PROTECTED]> escreveu: > What data type did you use to define the binary > column? bytea or LO? > > On Thu, 2004-06-24 at 14:16, Eduardo S. Fontanetti > wrote: > > How can I do to put a file into the PostgreSQL ? I > > have got the contents of file

[ADMIN] Insert binary data on postgre

How can I do to put a file into the PostgreSQL ? I have got the contents of file in binary yet and put on a String on my APP, but when I try to insert it on postgre, it returns to me: ERROR: parser: unterminated quoted string at or near "BMæ»
' at character 90 My string: ConnP.Execute "insert in

[ADMIN] Backup / Restore

? pg_dump? If yes, what options I need to use? Thanks a lot!! Eduardo S. Fontanetti __ Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis! http://br.info.mail.yahoo.com/ ---(end of broadcast

[ADMIN] Problem saving some characters

do a Select, it returns "S:directoryapp". It could be caused by the encoding type? I am using the Latin2. Somebody could help me? Whatever, it could be from the ODBC driver, but I don't know how to test it. Thanks! Eduardo S. Fontanetti ___