Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-21 Thread Albe Laurenz
Marcos Cano wrote: [missing data after dump/restore of DB with PostGIS] > i found this in the file... > > ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or > directory Could it be that PostGIS was not installed as an extension in the old database, so that the dump contains th

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
so i fix it and got it working !!! i followed the best practices of doing the dump with the newest pg_dump version. and now is working thanks everyone for your help -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827821.html Sent fr

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Bill Moran
On Thu, 20 Nov 2014 11:52:23 -0700 (MST) Marcos Cano wrote: > i found this in the file... > > ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or > directory > > > which acording to the firs link I found >

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
yes i'd better look at the postgis list.. i thought for one moment that this was encoding related. thanks for your help -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827760.html Sent from the PostgreSQL - general mailing list archi

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Adrian Klaver
On 11/20/2014 10:52 AM, Marcos Cano wrote: i found this in the file... What file? Remember the list need context for your statements. You are at the computer and see all that goes on. We only know what you tell us and statements without supporting data are hard to troubleshoot. ERROR: c

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
i found this in the file... ERROR: could not access file "$libdir/rtpostgis-2.0": No such file or directory which acording to the firs link I found , is a postgis

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Bill Moran
On Thu, 20 Nov 2014 11:25:10 -0700 (MST) Marcos Cano wrote: > i did it again... and the file shows exactly the same lots of : > > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N > invalid command \N

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
to answer to Adrian 1) i am using the old version to dump (i will try with the latest) 2) no the postgis version is different. pg9.2.4-> postgis-2.0.3 and pg9.3.5-> postgis-2.1.3 3) the schema is public \d+ al_shared_place Table "pu

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
i did it again... and the file shows exactly the same lots of : invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N invalid command \N -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-no

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Adrian Klaver
On 11/20/2014 10:06 AM, Marcos Cano wrote: might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors 2) the script + command is not writing to stderr (i think it is doing it) Aah, meant to add: Is there anything in the Postgres log for the time period of the re

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Adrian Klaver
On 11/20/2014 10:06 AM, Marcos Cano wrote: might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors So to be clear the file below does not exist?: 2>$backup_path/$db_upgrade_errors.txt" or it exists but there is nothing in it? 2) the script + command is

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Adrian Klaver
On 11/20/2014 09:47 AM, Marcos Cano wrote: hello im trying to dump a complete DB, i've been doing something like this. (i'm in the process of upgrading from 9.2.4 to 9.3.5) my current DB looks like this: Name| Owner | Encoding | Collate | Ctype | Access privileges ---+-

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
might be awkard but there is no file, so i assume 2 things: 1) there was no upgrade errors 2) the script + command is not writing to stderr (i think it is doing it) -- View this message in context: http://postgresql.nabble.com/pgdump-9-2-4-not-dumping-all-tables-tp5827736p5827739.html Sent

Re: [GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Tom Lane
Marcos Cano writes: > everything seems to work fine until i noticed that i'm missing 5 tables, Did you look at the error output from the restore to see if there were any complaints? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

[GENERAL] pgdump (9.2.4) not dumping all tables

2014-11-20 Thread Marcos Cano
hello im trying to dump a complete DB, i've been doing something like this. (i'm in the process of upgrading from 9.2.4 to 9.3.5) my current DB looks like this: Name| Owner | Encoding | Collate | Ctype | Access privileges ---+--+---+-+---