Chris White (cjwhite) [EMAIL PROTECTED] writes:
I have done a backup of my 7.4.2 database using pg_dump. When I restore
the database using the -c option I get the following error message and
pg_restore fails
pg_restore: [archiver (db)] could not execute query: ERROR: trigger
I got around the problem by using the --disable-triggers option on the
restore.
Chris
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 9:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Problems doing a restore under 7.4.2
Tom Lane wrote:
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
in my database i have both tsearch1 and tsearch2 .
the following sequence of commands lead to this
repeatble problem .
I get a t result in 7.4 tip.
Any solution ?
Possibly you should be running something newer than
Hi
I'm trying to restore tsearch2 featuring database like discribed in the
'tsearch-V2-intro' document.
(http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html)
In point '5) Restore the data for the database' I get the following Error:
pg_restore: ERROR: duplicate
Hello *,
I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.
newsdb=# select lower('kosteuer');
lower
kosteuer
(1 row)
newsdb=# select lower('Andreas');
lower
-
andreas
(1 row)
Any Ideas ?
Some additional infos to my problem
Old System: Postgresql 7.3.2
New System: Postgresql 7.4.1
pg_dump (PostgreSQL) 7.3.2
(pg_dumpall -g GLOBALobjects.sql)
pg_dump -s DATABASE DBschema.sql
pg_dump -Fc DATABASE DBdata.tar
and rebuilt on the new system with:
psql (PostgreSQL) 7.4.1
1.
Andreas Schmitz [EMAIL PROTECTED] writes:
I have a problem with select lower() using capital letters with diaeresis. I
tried with encoding SQL_ASCII und UNICODE.
upper/lower currently only work with single-byte characters, so you need
to use one of the LATINn database encodings rather than
Hello,
A client database crashed last night and I think I found the solution to
the problem at http://www.varlena.com/varlena/GeneralBits/45.php Database
Recovery Procedures . The solution was to append the file with enough
zeros to get the file size correct. The solution was to run
dd
Am Donnerstag, 22. April 2004 10:55 schrieb Andreas Schmitz:
I have a problem with select lower() using capital letters with diaeresis.
I tried with encoding SQL_ASCII und UNICODE.
You need to set your locale to something useful (de_DE), not the encoding.
And lower() doesn't work with
Kevin Schroeder [EMAIL PROTECTED] writes:
PANIC: XLogWrite: write request 1/383BE000 is past end of log 1/383BE000
The correct solution to this is to update your 7.3.3 installation to a
version without that page-boundary-case bug; as long as you're on 7.3.3
you have a one-in-several-hundred
On Thu, Apr 22, 2004 at 16:46:31 -0400,
Glenn MacGregor [EMAIL PROTECTED] wrote:
No problem this works great!
Now I have changed my data to
vid vname parentname
1 [EMAIL PROTECTED]
2 [EMAIL PROTECTED] n1
3 [EMAIL PROTECTED] n1
4 [EMAIL
Fischer,
probable scenario:
after step 3. you have tables pg_ts_* and when you restore your database
you tried to insert duplicated data.
I recommend to see remove any entries related to pg_ts_* tables.
Oleg
On Thu, 22 Apr 2004, Fischer Ulrich wrote:
Some additional infos to my
Fischer Ulrich [EMAIL PROTECTED] writes:
pg_dump (PostgreSQL) 7.3.2
(pg_dumpall -g GLOBALobjects.sql)
pg_dump -s DATABASE DBschema.sql
pg_dump -Fc DATABASE DBdata.tar
and rebuilt on the new system with:
psql (PostgreSQL) 7.4.1
1. createdb DATABASE
2. (psql DATABASE
Oleg,
this is exactly what I tryed to. But after cleaning all the new pg_ts_*
tables I wasn't able to restore my datas. My work arround is now to
rename all keys in the pg_ts_* tables (Ex: pg_ts_dict: dict_name: simple
to simple_old). With this modification the pg_restore worked!
Now I only
Fischer Ulrich [EMAIL PROTECTED] writes:
Tom Lane wrote:
This is certainly not going to work because the dump from the old
database will already have all the tsearch2 objects, not to mention
whatever setup_ge_ispell.sql may create. You should get rid of steps
3 and 3a.
Get rid of Step 3
Tom Lane wrote:
Fischer Ulrich [EMAIL PROTECTED] writes:
pg_dump (PostgreSQL) 7.3.2
(pg_dumpall -g GLOBALobjects.sql)
pg_dump -s DATABASE DBschema.sql
pg_dump -Fc DATABASE DBdata.tar
and rebuilt on the new system with:
psql (PostgreSQL) 7.4.1
1. createdb DATABASE
2. (psql
16 matches
Mail list logo