Skip site navigation (1) Skip section navigation (2)

Re: restaurar backup con campo bytea

From: "Crispin T(dot)" <cris(dot)emis(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: pgsql-es-ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: restaurar backup con campo bytea
Date: 2011-01-28 12:57:22
Message-ID: AANLkTikKgZGidBqjcf08t74ow4PoWO0SSwu5FQkrv62A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
>
> ¿Qué versiones están involucradas?
>
> hola Alvaro.
intente
       backup en 8.3.2  restore en 8.3.2
       backup en 9.0     restore en 9.0
       backup en 9.0     restore en 8.3.2

el trabajo que voy a realizar de forma periodica es backup en 9.0 y restore
en 8.3.2 pero no deveria de dar problemas ya que es un backup .sql  o si?

bueno en ninguna de las versiones me reconose el insert en todas es el mismo
error.

tupla a insertar

  INSERT INTO configuracion_web VALUES ('dato de prueba', 'dato de prueba',
123456, 'dato de prueba', '64-14996', 1234567, 'dato de prueba', 'dato de
prueba', 'dato de prueba', '',
'\\xffd8ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00014080042008004012200021101031101042200ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000e040100021103110400003f00f7fa28ac8d5f595b01e5c603ce79c1e8a3deb0c46229e1e9ba955d922e9d3954972c56a7bfd14515ac5947538a83edf661b6fdaa1dde9e60cd7179bed5253feb676cf6e8bfd054e341d488e6103eae3fc6bc259e622abbe1e8392efaff0091ddf52a70d2a54498514515da0607a1cd2e6b8b4b2d634ff9e34950679f2c8607f01572d3c4b2c6765dc5bf1c165e08fc3ffd55d14b3ba69a8e260e9bf35a7dff00f00ce58295af4da97a0514515d451505ade41791f99048aebdf1d47d454f5ed42719a528bba671b4d3b30a28a28a28a2a8414514514514500145145145145001451451451450014514555bfbb5b3b2927619da381ea7b571f045f6b9a4b9ba90888365d80c9663d147bd6bf8a66c470423b92e7f0e07f334dd3ed91753b6b674ff0053079a41ff009e87193fa8fcabe5b316f178d545fc30b7a36fbfcbf2f33d3c3feea839f57f920a28a2b76ce148ad91521110c7dcf4fafbd62788fc65a7786756d134dbd82ea49b58b8fb3db985032ab65465b246065c74c9ebc715d18e955afa169ad5fcb50d2ae1e3cb10378e572476cf5f6cd7d3c22a31515d0f35bbbb851451583e187f133eb3e225d727b392ca2bc09a7ac0b8658caeec3703f8593d4e7776c56ddde9d6d7aa44d12963d1c0c30fc6a95c6abe559ea5736db5bcab15bc8f729e4957c67dbe41efd6b84f855f14b52f1fead7f6b79636b6d1dac0240622c4b12d8ef4aa538548f2cd5d0464e2ee98514515d25de9d79a34bf68b6918c59fbea3a7d456ce95adc77c0452011cfe9d9be9fe156ed351b2d552e05acc93ac32b5bcdb790ae3aa9fceb9bd634b6d3a71710122166cae0f28dd6be7ebd0ab954bdb61f5a7f6a3dbcd1df4ea4314b92a7c5d18514515d851597a3ea42fedc86e264e1c0efef5a95eed0af0af4d54a6ee99c3383849c65ba0a28a28a28a2b62428a28a28a2a926ad6326ad2696970a6f638fcd787b85e39fd47e74584da41451455da28a2818514515c9789f9d4a204f0221ff00a11abf7ee34fd62daf8e44522f9721f4ff003c7e551789edc9486e02f0a4ab1c7af4a9e011eb7a2794edfbd500127a861d0fe3fd4d7cc384beb95e9af8df2ca3e76feac7a575ec69c9edaa7f30a28a2aec9ad69906ab6fa54b7f6c9a85ca1921b669007914752077e87f23e8717cf22bcf534dd1a6d7ed6ff5bd3527beb1430c170f9263539ca95ce187ccd8c838cf15d7c1a7e8d711878acac5d7d56153fd2bd9c1e3e962a3eebb4baaea8e3ad42749ebb770a28a2b135eb96d36c35784d95f4fe7db488b347106544c3302cdc00a0bb003a80bee33f3f7c20d6a4d057c45716e0b5e4d6d1dbdaa0ead2b390303be396c77c62be82d6347d3ae747d56efec51c621b797c808be5f2aa72c40033c8c0ce461411d6be71f85f6d72ffdafa85980d71a5082fd508c8708e720fd0127f0af469a4e4ae72d56d41b41451457d43e16d0e3f0e7876d34e50bbe34ccacbfc521e58fbf3d3d80a65d788bc37710cb6f36b9a66082ac0ddc7907f3f5ad1d3b508354d32defad9b7453c6244cf5c1ec7dc743f4af26d52eece5f86577fd97a05dad8487725f5c3444ff00ae19ce0eeeb91d29aa4ab5e33eba3f999ceafb28ae4edf90514515d769d790e91a9b35e4f15bc2bba396495c2aafa72781c803f1ae96d3c41a35fdc0b7b3d5ac6e2660488e1b84762075e01cd72daef87ae75b6bd8ad248e278da3953cd5ca3b8c36d6c7638e69341bbd3757f12da9bdb39749d7f4f8e45365b555240c30581c7cc38e307d7a8e6bc8c930ce8e1a717d252b7a2d3f33b71d5dcab46dd520a28a2bacbcd7749d3a7f22fb54b3b69b01b64d3aa360f7c13d38ab1677d6ba85b8b8b2b986e212481242e1d491d791c571f7d75687c6f7ad6fa25e6a77f05ac714c034423552772e0391cfbd4df0dce7c3b72c62f289bf9c9438cafcdd38f4af61c128731c71aadd4e5f5fc028a28aec8f02bc92c2e241f155b5b5631dbdcea571a5ca3b131c48139efb881c7fb35ea77d77158d85c5dccc162822695c9ecaa327f415e249ae699078034a027ceaf69a82dfbc66190076121fe2dbb7ee953d7f87b9aba316efe7a7de6789924d5fa6bf70514515eea3a514d560ca082083ce453ab9ceb0a28a2a2b8812e2078a45ca30c115c8bc777a0dfef504c64e01fe171e87debb3a8e58239e331ca81d0f5561906bcdc7e5eb1369c1f2ce3b33a2857f6574d5e2f7414514561491d8ebea1924f26e80e411cfe5deb1a6b27b4d5a3b08aeeddefd90ca9047281288f9f9caf50b918cf4cf19ad7bbf0d6d72f6736dc7211fb7d0d73d2f86e583c490ebef6323ead1218d2e865c85208c10320f048e4578388a3ef736328cb9bf9a1d4eea73d2d466adda4145145683d9eb0966d66629becef198cc60e46dc631c7418ac5f0e78262f0b4f3cba2692f6b25c26c9496670cbd71f3922ba4b5b9d6a6bd8525f38465c6ecc414633cf38aea40e2ba703835898b953ab5229777633af59d3769462fd028a28ae63c3ba2dee8f651d94056dacd18b08cb798c3272719ce3273deb9a1e04f13ff00c22ade1d1ac69eb6099d8a206dd265f7fccc7eee0f3c03e95d66b965a84f713bda45238302ac65640b87db373c91dda3cfe1e9514d65a98076db799189a76db1b88dca138400963d98b76c6d1c7afd1e169bc3c6ca4e5e727767995a31abbab7a681451454be26d027d6345fb2d9cb0c572b3c73869412a5908eb8e7a0aa567a27882e3c5163ab6b371a66cb38a4444b3490162e00e7713e9fe7b6a9d3a49ec21428d03890f99ce58a1241e41e38391c9c71e9556f2c3536bc98da2c688675688bafca17ca20e7e6e46eedb473cf3db68c9c5597f5721d38b9733feac14514550bef0ef8813c537daa68fa8d9411df2469219a26678f60c7ca3a1f5e7ffd773c3fa06a3a2786ef2cbed90bdf4b24d24770ab850edf749073df9c73f8d25ce937ef05a94dc0877f3515be6dbe5b81cee00fcdb71d39c13d291b4ed50dd44c13f74b752338181988cd195fe239f9431edc6571cf2dd46d584a9453e65fd5c28a28ab3aa699a9ea1e0d974c37501d466b6586599c61198801ce00e3237638ef497be1b4b9f04b78795c7166b6f1bbf4dcaa02b1c7b806ab5be9daa476107ee089d1958acb229dd887904e4f05febd73da9b1697aa88a34756cfd8f63b160c7cdf2c0c83bb00eecf383fd6973329d38bdfb5828a28ab91e9dacdbe8da25a5b5fc4935ab42b78e57709a355c3a8c83c9e39e2b7b35cf5969d771977bc81a562c72a920c1fde4a7e505b81831fe181daade936f7304ee2685d17cb5f99a40416e723009fcf8fc7ad26ee528d828a28ad7a28a290c28a28a28c5145200a28a28a28a29805145145145140051451451451400514514514514005145145145140051451451451400514515fffd9',
'dato de prueba');

donde el penultimo dato es el bytea. tengo 4 tablas mas que tienen bytea y
en todas es el mismo error (todas inician con *\\* )




-- 
Solo alcanzaras el conocimiento conociendo la ignorancia.

In response to

Responses

pgsql-es-ayuda by date

Next:From: p valdesDate: 2011-01-28 12:57:44
Subject: Re: Expresiones arbitrarias en GROUP BY
Previous:From: Eduardo Arenas C.Date: 2011-01-28 12:48:05
Subject: Re: Consulta Fechas y between

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group