how can i rescue a db postgres

The sql file you've posted already contains all of the CREATE statements that will generate all of the tables, functions, and types and load them with data. All you need to do is create a new empty database on a different server and execute that sql file.

c:\Program Files\Postgresql\9.0\bin\psql.exe -f 2013-01-27.sql

c:\Program Files\Postgresql\9.0\bin\psql.exe --help

hi

i'm running  the query, but i have error on this line


COPY bitacora (fecha, usuario, tabla, accion, id_registro) FROM stdin;
2011-10-01 23:00:20.174      lcuenca      pedido      INSERT      60087
2011-10-01 23:00:20.174      lcuenca      productospedido      INSERT      105949
2011-10-01 23:00:20.174      lcuenca      productospedido      INSERT      105950
2011-10-01 23:00:20.174      lcuenca      pedido      INSERT      60088
2011-10-01 23:00:20.174      lcuenca      productospedido      INSERT      105951
2011-10-01 23:00:20.174      lcuenca      productospedido      INSERT      105952
2011-10-01 23:00:20.174      lcuenca      productospedido      INSERT      105953


the error is :

ERROR:  error de sintaxis en o cerca de «2011»
LINE 28767: 2011-10-01 23:00:20.174 lcuenca pedido INSERT 60087
            ^

********** Error **********

(spanish)  it's mean.... sintax error in or near 2011


i'm debugging some querys errors , but i don't know how debug it...and there are various lines with this structure

have you some idea how can i debug it?

thanks a lot

Are you running it from the console like earthman2 suggested or through pgAdmin?

You should be using the console. I just ran it on my test setup and it created 22 tables and loaded them with data with only errors being the missing role. If you use pgAdmin you will get the syntax error you are describing above.

To run it from a console in windows, open a command prompt and execute earthman2's command:
psql.exe -f 2013-01-27.sql

To run it from a console in linux, open an SSH session and execute the same command.

hi ivanovn

i made from console but send me passwrord wrong

then i open de sql file , and let me advance till that error

what can is it?

thenks a lot


C:\Program Files\PostgreSQL\9.2\bin>psql.exe -f2013-01-27.sql
Contrase±a:
psql: FATAL:  la autentificación password falló para el usuario «aenriquez»

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -f2013-01-27.sql
Contrase±a:
psql: FATAL:  la autentificación password falló para el usuario «aenriquez»

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -f2013-01-27.sql
Contrase±a:
psql: fe_sendauth: no password supplied

C:\Program Files\PostgreSQL\9.2\bin>

You need to supply additional parameters to your psql command. See the documentation for all available options: http://www.postgresql.org/docs/9.2/static/app-psql.html

For example, if the DB you are restoring the data to is located on your local machine and is called "testdb", the user is "testuser" and password is "testpassword" the command would look something like this:

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -h localhost -d testdb -U testuser -f 2013-01-27.sql

After you execute that, you will be prompted for the password, and you would type in testpassword.

hi ivanovn

thans a lot a lot

i think we advance...

i run so:

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -h localhost -d cat2 -U postgres -f
2013-01-27.sql

now....run, and create 22 tables, but i see some tables, and only record one record..example

example, i attach an image with data view from productospedido table

this was the command results  at the command dos :

ALTER TABLE
 setval
--------
   1012
(1 fila)


 setval
--------
  39736
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
    900
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
    168
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
 129552
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
   5635
(1 fila)


 setval
--------
  60663
(1 fila)


psql:2013-01-27.sql:2313: ERROR:  la relación «perfiles_id_seq» ya existe
ALTER TABLE
 setval
--------
     13
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
  14750
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
     10
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
     20
(1 fila)


CREATE TABLE
ALTER TABLE
 setval
--------
   7438
(1 fila)


 setval
--------
 119012
(1 fila)


psql:2013-01-27.sql:2441: ERROR:  la relación «reenvios_id_seq» ya existe
ALTER TABLE
 setval
--------
  65302
(1 fila)


CREATE VIEW
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
 setval
--------
     45
(1 fila)


 setval
--------
   6235
(1 fila)


CREATE VIEW
ALTER TABLE
CREATE TABLE
ALTER TABLE
 setval
--------
     11
(1 fila)


psql:2013-01-27.sql:2566: ERROR:  no existe la columna pg_authid.rolconfig
LÍNEA 2: ..., (pg_authid.rolvaliduntil)::abstime AS valuntil, pg_authid....
                                                              ^
psql:2013-01-27.sql:2569: ERROR:  no existe la relación «public.usuaria»
psql:2013-01-27.sql:2576: ERROR:  no existe la columna pg_authid.rolconfig
LÍNEA 2: ..., (pg_authid.rolvaliduntil)::abstime AS valuntil, pg_authid....
                                                              ^
psql:2013-01-27.sql:2579: ERROR:  no existe la relación «public.usuario»
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE VIEW
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
CREATE TRIGGER
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
REVOKE
REVOKE
GRANT
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT
REVOKE
REVOKE
GRANT

C:\Program Files\PostgreSQL\9.2\bin>psql.exe -h localhost -d cat2 -U postgres -f
2013-01-27.sql




you know what can i do??

thanks a lot a lot a lot
data-view-productospedido-table.jpg

thanks ivanovn

i did you tell me

i complete missing pieces and now it run fine

thanks a lot