On 14/01/13 01:13, sub3 wrote:
Hi,
I am having an issue upgrading a really old 8.2 db up to 9.2.2. One of the
tables contains a bytea field. When I backup& restore using pgadmin from
my 9.2.2 install, it doesn't convert this field correctly.
Could this be due to your bytea_output setting?
h
Siva Palanisamy wrote:
> However, I get the same list of errors as below. The weird thing is,
it appears to be working fine. I
> could not able to comprehend the error list! I don't have any clue
about it!
>
> For your information, I don't think am running using the superuser
account! But just seem
Siva --
>
> Thanks a lot for your reply. As usual Backup worked perfectly. When I tried
> restore using the command you provided, I got the below list of errors!
> Please help me > out on this.
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error fro
o:amitabhk...@gmail.com]
Sent: Monday, August 08, 2011 2:42 PM
To: Siva Palanisamy
Cc: John R Pierce; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backup & Restore a database in PostgreSQL
Hi Siva
Not sure if it would help, but try passing -O in your pg_restore command.
Amitabh
On Mon, Aug 8, 2
Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: Monday, August 08, 2011 1:45 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Backup & Restore a database in PostgreSQL
&g
stgresql.org] On Behalf Of John R Pierce
Sent: Monday, August 08, 2011 1:45 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backup & Restore a database in PostgreSQL
On 08/08/11 1:01 AM, Siva Palanisamy wrote:
>
> Hi All,
>
> I am also a newbie here! I need to backup a
On 08/08/11 1:01 AM, Siva Palanisamy wrote:
Hi All,
I am also a newbie here! I need to backup a database and restore it
into the target machine where the database may already present or
might not. If it exists, I want the "restore" command to overwrite,
otherwise, just create a new one.
I
On Tuesday, February 08, 2011 10:41:15 am Lee Hughes wrote:
> From section 15.4 of the manual:
>
> "If you are upgrading from PostgreSQL "9.0.x", the new version can use
> your current data files so you should skip the backup and restore steps"
>
> Is 9.0beta4 considered a 9.0.x version, or do I
On Fri, 2008-07-18 at 20:25 -0400, Francisco Reyes wrote:
> Does pg_snapclone works mostly on large rows or will it also be faster
> than pg_dump for narrow tables?
It allows you to run your dump in multiple pieces. Thats got nothing to
do with narrow or wide.
--
Simon Riggs www.2n
Simon Riggs wrote:
Have a look at pg_snapclone. It's specifically designed to significantly
improve dump times for very large objects.
http://pgfoundry.org/projects/snapclone/
Also, in case the original poster is not aware, by default pg_dump
allows to backup single tables.
Just add -t .
On Wed, 2008-05-07 at 15:24 -0700, John Smith wrote:
> Actually, I forgot to mention one more detail in my original post.
> For the table that we're looking to backup, we also want to be able to
> do incremental backups. pg_dump will cause the entire table to be
> dumped out each time it is invok
Hi Tom,
Actually, I forgot to mention one more detail in my original post.
For the table that we're looking to backup, we also want to be able to
do incremental backups. pg_dump will cause the entire table to be
dumped out each time it is invoked.
With the pg_{start,stop}_backup approach, increm
"John Smith" <[EMAIL PROTECTED]> writes:
> After reading the documentation, it seems like the following might
> work. Suppose the database has two tables foo and bar, and we're only
> interested in backing up table foo:
> 1. Call pg_start_backup
> 2. Use the pg_class table in the catalog to get
On Wed, 2008-05-07 at 13:02 -0700, John Smith wrote:
> I have a large database (multiple TBs) where I'd like to be able to do
> a backup/restore of just a particular table (call it foo). Because
> the database is large, the time for a full backup would be
> prohibitive. Also, whatever backup mec
On Wed, 7 May 2008 16:09:45 -0400
"David Wilson" <[EMAIL PROTECTED]> wrote:
> I'm fairly certain that you have to be very careful about doing simple
> file copies while the system is running, as the files may end up out
> of sync based on when each individual one is copied. I haven't done it
> mys
On Wed, 7 May 2008 13:02:57 -0700
"John Smith" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a large database (multiple TBs) where I'd like to be able to do
> a backup/restore of just a particular table (call it foo). Because
> the database is large, the time for a full backup would be
> prohibiti
On Wed, May 7, 2008 at 4:02 PM, John Smith <[EMAIL PROTECTED]> wrote:
> Does anyone see a problem with this approach (e.g., correctness,
> performance, etc.)? Or is there perhaps an alternative approach using
> some other postgresql mechanism that I'm not aware of?
Did you already look at and
Bob Pawley wrote:
Found it in template 1. This seems strange as both servers and pgadmins
are the same version and I haven't opened the template until today.
The only thing I can think of is that you accidentally restored into
template1. Probably easier to do with pgadmin than from the command
<[EMAIL PROTECTED]>; "Shoaib Mir" <[EMAIL PROTECTED]>;
"Postgresql"
Sent: Wednesday, January 03, 2007 10:44 AM
Subject: Re: [GENERAL] Backup Restore
Bob Pawley wrote:
Looking through PGAdmin where would I find the spatial references that
the errror message refer
Bob Pawley wrote:
Looking through PGAdmin where would I find the spatial references that
the errror message references?
Bob Pawley wrote:
Following is the error message on pg_restore:-
"pg_restore: ERROR: duplicate key violates unique constraint
"spatial_ref_sys_pkey"
CONTEXT: COPY spatia
Mir" <[EMAIL PROTECTED]>;
"Postgresql"
Sent: Tuesday, January 02, 2007 2:00 AM
Subject: Re: [GENERAL] Backup Restore
Bob Pawley wrote:
Following is the error message on pg_restore:-
"pg_restore: ERROR: duplicate key violates unique constraint
"spatial_ref_sys_
he error.
Any thoughts??
Bob
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Shoaib Mir" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Friday, December 29, 2006 12:10 AM
Subject: Re: [G
Bob Pawley wrote:
Following is the error message on pg_restore:-
"pg_restore: ERROR: duplicate key violates unique constraint
"spatial_ref_sys_pkey"
CONTEXT: COPY spatial_ref_sys, line 1: "2000 EPSG 2000 PROJCS["Anguilla
1957 / British West Indies Grid",GEOGCS["Anguilla 1957",DATUM["Angui...
iginal Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Shoaib Mir" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Friday, December 29, 2006 10:57 AM
Subject: Re: [GENERAL] Backup Restore
Bob Pawle
Bob Pawley wrote:
Hi Dave
I can get the restore working if I dump the project spelling out
"*.backup" and not relying on the default.
However the restore is being aborted due to a pk error for the spatial
coordinates. I've removed the gis feature from both applications but
still get the er
Bob Pawley wrote:
When I change it to view "all files" it's there - but it won't do anything.
So I assume you've used a different extension than the one the dialogue
is expecting by default?
When you say "it won't do anything." do you mean you cannot select the
file, or that nothing happens
uot;Postgresql"
Sent: Thursday, December 28, 2006 12:06 PM
Subject: Re: [GENERAL] Backup Restore
Bob Pawley wrote:
I'm not getting an error message. The restore utility just doesn't see
the backup file. It's looking for a file *.backup which is there but noot
seen.
It
Bob Pawley wrote:
I'm not getting an error message. The restore utility just doesn't see
the backup file. It's looking for a file *.backup which is there but
noot seen.
It's a standard file dialogue as provided by your operating system. I
can't think of any reason it wouldn't see the file unl
sing an earlier version??
Bob
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Shoaib Mir" <[EMAIL PROTECTED]>
Cc: "Bob Pawley" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Thursday, December 28, 2006 11:30 AM
Subj
Shoaib Mir wrote:
Well I haven't use much of PGAdmin but I will always be using pg_dump
and pg_restore for that as they are really easy to use.
You can find help on backup and restore at -->
http://www.postgresql.org/docs/8.2/static/backup.html
pgAdmin is just a frontend to pg_dump/pg_restor
Well I haven't use much of PGAdmin but I will always be using pg_dump and
pg_restore for that as they are really easy to use.
You can find help on backup and restore at -->
http://www.postgresql.org/docs/8.2/static/backup.html
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
Art Fore wrote:
Using PGadminIII, I backup my database on linux machine, and try to
restore it on the windows machine. Alway comes up with duplicate key
on the first item. I drop all views and the only table in the
database and try again. Still same thing. I do a refrresh, none of the
views or
32 matches
Mail list logo
