PDA

View Full Version : Database restore fault errors



Beffa
03-24-2010, 07:19 AM
I get these errors when trying to restore my database, this is some of it:



pg_restore: kopplar upp mot databas för återställning
pg_restore: skapar SCHEMA public
pg_restore: skapar COMMENT SCHEMA public
pg_restore: skapar PROCEDURAL LANGUAGE plpgsql
pg_restore: [arkiverare (db)] Fel vid HANTERING AV TOC:
pg_restore: [arkiverare (db)] Fel på TOC-post 432; 2612 16386 PROCEDURAL LANGUAGE plpgsql postgres
pg_restore: [arkiverare (db)] could not execute query: ERROR: language "plpgsql" already exists
Command was:
CREATE PROCEDURAL LANGUAGE plpgsql;
pg_restore: skapar TYPE responetype3_month_response
pg_restore: [arkiverare (db)] Fel på TOC-post 430; 1247 221230 TYPE responetype3_month_response postgres
pg_restore: [arkiverare (db)] could not execute query: ERROR: relation "responetype3_month_response" already exists
Command was: CREATE TYPE responetype3_month_response AS (
player_id integer,
compiledplayerresults_id integer,
totalplayedhands intege...
pg_restore: skapar TYPE responetype3_response
pg_restore: [arkiverare (db)] Fel på TOC-post 428; 1247 221226 TYPE responetype3_response postgres
pg_restore: [arkiverare (db)] could not execute query: ERROR: relation "responetype3_response" already exists
Command was: CREATE TYPE responetype3_response AS (
player_id integer,
compiledplayerresults_id integer,
totalplayedhands smallint
);
pg_restore: skapar FUNCTION getmatchingcompiledplayerresults(integer, integer, timestamp without time zone, timestamp without time zone, integer[])
pg_restore: [arkiverare (db)] Fel på TOC-post 20; 1255 221227 FUNCTION getmatchingcompiledplayerresults(integer, integer, timestamp without time zone, timestamp without time zone, integer[]) postgres
pg_restore: [arkiverare (db)] could not execute query: ERROR: function "getmatchingcompiledplayerresults" already exists with same argument types
Command was: CREATE FUNCTION getmatchingcompiledplayerresults(integer, integer, timestamp without time zone, timestamp without time zone,...
pg_restore: skapar FUNCTION getmatchingcompiledplayerresults_month(integer, integer, integer, integer, integer[])
pg_restore: [arkiverare (db)] Fel på TOC-post 21; 1255 221231 FUNCTION getmatchingcompiledplayerresults_month(integer, integer, integer, integer, integer[]) postgres
pg_restore: [arkiverare (db)] could not execute query: ERROR: function "getmatchingcompiledplayerresults_month" already exists with same argument types
Command was: CREATE FUNCTION getmatchingcompiledplayerresults_month(integer, integer, integer, integer, integer[]) RETURNS SETOF responet...
pg_restore: skapar FUNCTION getwinningplayerjoincashver2(integer)
pg_restore: [arkiverare (db)] Fel på TOC-post 22; 1255 16722 FUNCTION getwinningplayerjoincashver2(integer) postgres
pg_restore: [arkiverare (db)] could not execute query: ERROR: function "getwinningplayerjoincashver2" already exists with same argument types
Command was: CREATE FUNCTION getwinningplayerjoincashver2(integer) RETURNS text
LANGUAGE plpgsql
AS $_$DECLARE

netsrak
03-24-2010, 11:03 AM
Create a new empty database via pgadminII (not in Holdemmanager!) using the same coding as the original database and then try to restore the backup into this database.