Re: [GENERAL] Backup and Restore pgAdmin Win 7 (64bit ultimate)

Le 23/02/2011 09:58, Interrogativus a écrit : > Hi there, > > I am currently running Version 1.12.2 (Dec 14 2010, rev: REL-1_12_2) / > PostgreSQL 9.02 on Windows 7 Ultimate (64-bit) > > The problem is the exactly the same as described in this thread > http://postgresql.1045698.n5.nabble.com/Error

Re: [GENERAL] Backup and restore sequences

On 01/07/2011 08:26 AM, gvim wrote: On 07/01/2011 15:58, Adrian Klaver wrote: Details below. When you dump a specific table using -t it will not automatically dump dependent objects. -t can be used to dump a sequence because they are just a special type of table. From: http://www.postgresql.or

Re: [GENERAL] Backup and restore sequences

On January 7, 2011, gvim wrote: > PostgreSQL 9.0.1/pgAdminIII 1.12.1 > > I want to copy selected tables from one database to another and maintain > the sequences which I originally setup with: > > CREATE SEQUENCE venues_id_seq START WITH 1122; > ALTER TABLE venues ALTER COLUMN id SET DEFAULT nex

Re: [GENERAL] Backup and restore sequences

On Friday 07 January 2011 7:46:31 am gvim wrote: > PostgreSQL 9.0.1/pgAdminIII 1.12.1 > > I want to copy selected tables from one database to another and maintain > the sequences which I originally setup with: > > CREATE SEQUENCE venues_id_seq START WITH 1122; > ALTER TABLE venues ALTER COLUMN id S

Re: [GENERAL] backup and restore

On 16/01/2008, Richard Huxton <[EMAIL PROTECTED]> wrote: > T.J. Adami wrote: > What puzzles me is that as far as I know, pgAdmin *uses* pg_dump and > pg_restore to handle its backup needs. It does. Make sure it's using the correct version for your server though - that's the only reason it might fa

Re: [GENERAL] backup and restore

T.J. Adami wrote: On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote: It's quite simple to have problems with pgAdmin's backup procedure. Hmm - shouldn't be, and if so then please let the pgAdmin people know! They're always working to improve the package and it's I think the same. We

Re: [GENERAL] backup and restore

the others in their vastness. For who will not be astounded at the fact that our body, which a little while ago was imperceptible in the universe, itself imperceptible in the bosom of the whole, is now a colossus, a world, or rather a whole, in respect of the nothingness which we cannot reach? He w

Re: [GENERAL] backup and restore

shall be sprinkled on his garments, so as to stain all his raiment. He will not only hate you, but he will have you in the utmost contempt: no place shall be thought fit for you, but under his feet to be trodden down as the mire of the streets. The misery you are exposed to is that which God wil

Re: [GENERAL] backup and restore

On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote: > > It's quite simple to have problems with pgAdmin's backup procedure. > > Hmm - shouldn't be, and if so then please let the pgAdmin people know! > They're always working to improve the package and it's > I think the same. We (company I

Re: [GENERAL] backup and restore

T.J. Adami wrote: On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote: Having recently jumped ship from MSSQL to Postgres I'm finding it a little difficult getting onto the 'correct path.' Basically I have a live database and I want to take a copy of that and then restore it onto a backup s

Re: [GENERAL] backup and restore

On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote: > Having recently jumped ship from MSSQL to Postgres I'm finding it a > little difficult getting onto the 'correct path.' Basically I have a > live database and I want to take a copy of that and then restore it > onto a backup server. > > Fi

Re: [GENERAL] backup and restore

Thank reply for me Can u show me How will i backup database on Function or proc on Database?? -- View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10427265 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(e

Re: [GENERAL] backup and restore

anhtin wrote: Anybody show for me ? i want backup database and i read on Internet have function pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup) but i not run Some body show me. How will i do run this function ?? Read the documentation! http://www.postgresql.org

[Fwd: Re: [GENERAL] backup and restore]

anhtin wrote: Anybody show for me ? i want backup database and i read on Internet have function pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup) but i not run Some body show me. How will i do run this function ?? See: http://www.postgresql.org/docs/8.2/static/co

Re: [GENERAL] backup and restore

anhtin wrote: Anybody show for me ? i want backup database and i read on Internet have function pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup) but i not run Some body show me. How will i do run this function ?? See: http://www.postgresql.org/docs/8.2/static/co

Re: [GENERAL] backup and restore

Anybody show for me ? i want backup database and i read on Internet have function pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup) but i not run Some body show me. How will i do run this function ?? -- View this message in context: http://www.nabble.com/backup-and

Re: [GENERAL] backup and restore

Anybody show for me ? i want backup database and i read on Internet have function pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup) but i not run Some body show me. How will i do run this function ?? -- View this message in context: http://www.nabble.com/backup-and

Re: [GENERAL] backup and restore

Anybody show for me ? i want backup database and i read on Internet have function pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup) but i not run Some body show me. How will i do run this function ?? -- View this message in context: http://www.nabble.com/backup-and

Re: [GENERAL] backup and restore

thanks reply for me but have propblem: the function pg_start_backup() i dont run this function Can u send me example is a procedure or function can backup and restore for me -- View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10391372 Sent from the Pos

Re: [GENERAL] backup and restore

On 09.05.2007 09:45, anhtin wrote: hi all I am developing web site use database is PostGres and now i must build function backup and Restore database on Web My web develop on framework 2.0(asp.net 2.0) I know have two file on forder bin use backup and restore is: pg_restore.exe , pg_dump.exe I ha

Re: [GENERAL] Backup and restore UTF8 data

On Fri, 2007-01-12 at 16:02 -0800, Benjamin Arai wrote: > > psql:outfile:151275: ERROR: invalid byte sequence for encoding > "UTF8": 0x92 > > Does anybody know what I can do to fix this? Here is a copy-paste from 8.1 release notes: ===

Re: [GENERAL] Backup and Restore mechanism in Postgres

On Tue, 20 Sep 2005, Lincoln Yeoh wrote: At 10:00 AM 9/20/2005 -0400, Vivek Khera wrote: On Sep 14, 2005, at 9:45 AM, vinita bansal wrote: I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD Just curious what ever came of this? Also, were you reading the DB and writing the

Re: [GENERAL] Backup and Restore mechanism in Postgres

At 10:00 AM 9/20/2005 -0400, Vivek Khera wrote: On Sep 14, 2005, at 9:45 AM, vinita bansal wrote: I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD and a 40GB database. I need to take backup of this database and restore it some other location (say some test environment). I am

Re: [GENERAL] Backup and Restore mechanism in Postgres

On Sep 14, 2005, at 9:45 AM, vinita bansal wrote: I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD and a 40GB database. I need to take backup of this database and restore it some other location (say some test environment). I am currently using pg_dump and pg_restore utili

Re: [GENERAL] Backup and restore from 7.4.1 to latest, crossing

Mark, > I currently have a defunct Debian 3.0 system running PostgreSQL 7.4.1, in > which I am going to do an entire blob backup dump of all the databases in > hopes to restore them on my new, more secure system running the latest > OpenBSD, and PgSQL 8.0. > > So my question is: Are they any issue

Re: [GENERAL] Backup and restore from 7.4.1 to latest, crossing platforms... issues?

Hi Martjin, That's what I meant.. I would do my pg_dumps using: pg_dump -U postgres -Ft -b dbname > dbname.tar And restore them via: pg_restore -O -U postgres -d dbname dbname.tar That should be cool, yes? MarkOn 7/27/05, Martijn van Oosterhout wrote: Binary backups are not

Re: [GENERAL] Backup and restore from 7.4.1 to latest, crossing platforms... issues?

Binary backups are not going to work across major releases so just installing 8.0 with your old cluster won't work. You'll need to do a pg_dump of your old setup and then restore on your new cluster. Hope this helps, On Wed, Jul 27, 2005 at 12:27:41AM -0400, Mark Mikulec wrote: > Hi there, > >

Re: [GENERAL] Backup and Restore of PostgreSQL

Well you might want to make sure the servlet only does one pg_dump at a time to a particular file in a secured directory (making sure you don't have any funny symlink problems) and all that sort of boring security, reliability and predictability stuff. Don't forget the UI. The dump could take a

Re: [GENERAL] Backup and Restore of PostgreSQL

9:57 AM To: Tim Penhey Cc: pgsql-general Subject: Re: [GENERAL] Backup and Restore of PostgreSQL Tim Penhey wrote: > Richard Huxton mentioned: > >> >>The pg_dump utility is the standard way to backup PostgreSQL and the >>custom format is already compressed. > The quest

Re: [GENERAL] backup and restore questions

On Fri, 20 Feb 2004, Sally Sally wrote: > Thank you all for replying. I appreciate the tips. Apologies to those who > were offended by the html formating. > Scott, quick question. The reason I assumed insert would be "safer" than > copy is because the docs say that in the case of copy it fails o

Re: [GENERAL] backup and restore questions

On Thursday 19 February 2004 17:41, Sally Sally wrote: > I had a few questions > concerning the backup/restore process for pg. Please don't post HTML if you can avoid it. > class=RTE>  > 1) Is it possible to dump data onto an existing > database that contains data (assumning the schema of both ar

Re: [GENERAL] backup and restore questions

On Thu, 19 Feb 2004, Sally Sally wrote: > I had a few questions concerning the backup/restore process for pg. >   > 1) Is it possible to dump data onto an existing database that contains data > (assumning the schema of > both are the same). Has anyone done this? I am thinking of this in order to

Re: [GENERAL] backup and restore questions

Dear Sally Sally , I had a few questions concerning the backup/restore process for pg. 1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same). Has anyone done this? I am thinking of this in order to expediate the data load proces