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

Re:

From: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re:
Date: 2007-06-20 14:33:32
Message-ID: 46793ABC.9080907@postgresqlfr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Vasoczki Ferenc a écrit :
> Hi!
>  
> I have several problems with pg_dump, and pg_restore, and pgadmin.
>  
> 1. Pgadmin:
> I have 2 Postgresql 8.2. One is on my machine (localhost, windows XP
> SP2), and one on the server (debian linux).
> I dumped my db from my database.
> As you wrote here
> (http://archives.postgresql.org/pgadmin-support/2006-11/msg00133.php),
> it just calls the binary from the command line and sets the params.
>  
> C:\Program Files\pgAdmin III\1.6\pg_dump.exe -i -h localhost -p 5432
> -U monarchia_uj -F p -O -D -v -f "C:\tmp\123.sql" monarchia_uj
>  
> Ok, the first problem is: It allow me to save with any extension, but
> the default is .sql, while when i want to restore, it supposes a .backup.
> This isn't a really bug, just now too usable.
>  
> I join to this opinion:
>  
>
>     Under Windows it won't remember the location I've saved dump to.
>     Instead, I'll always see my home folder. That's quite an unhandy
>     thing. E.g. I save a dump to c:\dumps and at the next step want to
>     restore it. Consider it more logical to see c:\dumps in the dialog
>     window.
>
> No - patches are always welcome :-)
> So, the real problem is:
> I want to restore this 123.sql into the servers postgresql.
> Open pgadmin, connect to server, go to database, right click and restore.
> I select the file, and the OK button is disabled. (readonly, grey,
> whatever). Why is that, i made my backup with this pgadmin, so it
> should be correct backup file.
> (I tried, to dump it out from  the console, and restore with pgadmin,
> there is the same situation).
>  
> Ok, no problem, i can use this dump like an sql query, so do it:
>  
> --
> -- PostgreSQL database dump
> --
>  
> SET client_encoding = 'SQL_ASCII';
> SET standard_conforming_strings = off;
> SET check_function_bodies = false;
> SET client_min_messages = warning;
> SET escape_string_warning = off;
>  
> --
> -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
> --
>  
> COMMENT ON SCHEMA public IS 'Standard public schema';
>  
>
> --
> -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
> --
>  
> CREATE PROCEDURAL LANGUAGE plpgsql;
>  
>
> SET search_path = public, pg_catalog;
>  
> SET default_tablespace = '';
>  
> SET default_with_oids = false;
>  
> --
> -- Name: admin_jogok; Type: TABLE; Schema: public; Owner:
> monarchia_uj; Tablespace:
> --
>  
> CREATE TABLE admin_jogok (
>     admin_id integer,
>     jog_id character varying(100),
>     aj_id integer NOT NULL,
>     alfuncid character varying(100)
> );
>  
>
> ALTER TABLE public.admin_jogok OWNER TO monarchia_uj;
>  
> --
> -- Name: admin_jogok_aj_id_seq; Type: SEQUENCE; Schema: public; Owner:
> monarchia_uj
> --
>  
> CREATE SEQUENCE admin_jogok_aj_id_seq
>     INCREMENT BY 1
>     NO MAXVALUE
>     NO MINVALUE
>     CACHE 1;
>  
>
> ALTER TABLE public.admin_jogok_aj_id_seq OWNER TO monarchia_uj;
>  
>
> --
> -- Name: admin_jogok_aj_id_seq; Type: SEQUENCE OWNED BY; Schema:
> public; Owner: monarchia_uj
> --
>  
> ALTER SEQUENCE admin_jogok_aj_id_seq OWNED BY admin_jogok.aj_id;
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>  
> The problem is here:
> ERROR:  syntax
> error at or near "OWNED"
>  
> I checked the manual, and i think the syntax is good. If i do it with
> pgadmin, then there wont be any table.
> If i run it from command line, the linux box says the errors, but
> create the tables, and insert the data.
>  
>  
> Ferenc Vasóczki
>  
Hi,

Are You sure you don't have two instances on your debian box ?
One in 8.1 and the other in 8.2 ?

That could explain the "owned by" error in that it didn't exist in 8.1,
I think.

Regards,
SAS

-- 
Stéphane SCHILDKNECHT
Président de PostgreSQLFr
06 13 60 37 44 - 09 53 69 97 12
http://www.PostgreSQLFr.org


In response to

  • at 2007-06-20 12:03:41 from Vasoczki Ferenc

pgsql-bugs by date

Next:From: Ondrej SevcikDate: 2007-06-20 16:20:30
Subject: BUG #3398: Regress test cannot be run with Makefile in postgresql-test-8.2.4
Previous:From: Andrew SullivanDate: 2007-06-20 14:24:43
Subject: Re: BUG #3397: change the pg_setting

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