pg_dumpall alldb.sql (store)
and
psql -f alldb.sql postgres (restore)
is it necessary to drop existing objects (for example roles, ...) ?
Any help is appreciated.
I think it is not necessary. pg_dumpall supports dumping of the entire
contents of a database cluster, It backs up each database in
pg_dumpall alldb.sql (store)
and
psql -f alldb.sql postgres (restore)
is it necessary to drop existing objects (for example roles, ...) ?
Any help is appreciated.
Last days i'm looking tot he options of pg_dumpall and I think the answer of my
question is using option -c.
Using this option
Hallo,
between
pg_dumpall alldb.sql (store)
and
psql -f alldb.sql postgres (restore)
is it necessary to drop existing objects (for example roles, ...) ?
Any help is appreciated.
On Mon, Jul 29, 2013 at 6:49 PM, Asmus Reinhard
reinhard.as...@spdfraktion.de wrote:
Hallo,
** **
between
** **
pg_dumpall alldb.sql (store)
** **
According above command,you are taking all databases dump in plain text
format which are available in PostgreSQL cluster
Thanks!
于 2012/9/7 20:20, Sergey Konoplev 写道:
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter ruralhun...@gmail.com wrote:
base_20120902.tar.gz
27781958.tar.gz
27781959.tar.gz
Now I want to restore it on another server with only one disk. I'm confused
how to handle those tablespace files. Is
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter ruralhun...@gmail.com wrote:
base_20120902.tar.gz
27781958.tar.gz
27781959.tar.gz
Now I want to restore it on another server with only one disk. I'm confused
how to handle those tablespace files. Is there a guideline or doc for this
kind of
Hi,
I have a database with several tablespaces on different disks and
backup-ed it with pg_basebackup. I have theses files:
base_20120902.tar.gz
27781958.tar.gz
27781959.tar.gz
Now I want to restore it on another server with only one disk. I'm
confused how to handle those tablespace files.
Hi folks,
My server has a daily routine to import a dump file, however its taking
long time to finish it.
The original db has around 200 MB and takes 3~4 minutes to export (there
are many blob fields), however it takes 4 hours to import using pg_restore.
What can I do to tune this database to
Hi folks,
My server has a daily routine to import a dump file, however its taking
long time to finish it.
The original db has around 200 MB and takes 3~4 minutes to export (there
are many blob fields), however it takes 4 hours to import using pg_restore.
What can I do to tune this database to
I'll certainly follow your advices.
The log_truncate_on_rotation parameter is set to on.
I figured that saves a lot of disk space in this context. this is hurting
the performance?
-
Marcos Oliveira
And I still haven't found what I'm looking for...
--
View this message in context:
On Fri, Sep 16, 2011 at 3:27 AM, marvin.deoliveira
marvin.deolive...@gmail.com wrote:
I'll certainly follow your advices.
The log_truncate_on_rotation parameter is set to on.
I figured that saves a lot of disk space in this context. this is hurting
the performance?
That option shouldn't have
On Thu, Sep 15, 2011 at 3:32 PM, marvin.deoliveira
marvin.deolive...@gmail.com wrote:
Hi.
I'm restoring a database (only rows) that has some tables with 9 millions
rows and others have even more.
It's going to slow ( more than 24 hours by now ).
I'm disabling the triggers but I guess if I
I'm using postgres 9.0.2 32 bits on Debian 5.
The hardware is a pc with 2 GB RAM, with 2 sata disks. Well, that's what I
have at the moment.
The restore was started like: pg_restore -U postgres --data-only
--disable-triggers -v /bck/dump file.sql -d database
The pg_restore shows:
pg_restore:
On Thu, Sep 15, 2011 at 4:12 PM, marvin.deoliveira
marvin.deolive...@gmail.com wrote:
I'm using postgres 9.0.2 32 bits on Debian 5.
The hardware is a pc with 2 GB RAM, with 2 sata disks. Well, that's what I
have at the moment.
The restore was started like: pg_restore -U postgres --data-only
The dump file is in a different disk than a database.
I need to have this restore finished ( it is about 80% done )
I will have to do it again, but with the changes.
I will return the results to this post.
-
Marcos Oliveira
And I still haven't found what I'm looking for...
--
View this
Dear all,
I am using Postgres-8.4.2 on Windows system.
I have 2 databases in my postgres database ( globedatabase (21GB),
urldatabase).
I restore globedatabase from a .sql file on yesterday morning.I insert
some new data in that database.
In the evening, by mistake I issued a *drop database
On Jul 25, 2011, at 12:08 PM, Adarsh Sharma wrote:
I restore globedatabase from a .sql file on yesterday morning.I insert some
new data in that database.
In the evening, by mistake I issued a drop database globedatabase command.
Today morning, I restore again the same database from backup
I go through the link, so it is impossible to get the data back.
I have following files in my pg_xlog directory :
000100070091
000100070092
000100070093
000100070094
000100070095
000100070096
000100070097
* Adarsh Sharma:
I restore globedatabase from a .sql file on yesterday morning.I insert
some new data in that database.
In the evening, by mistake I issued a *drop database globedatabase* command.
Today morning, I restore again the same database from backup (.sql) file.
My .sql file have
sonnix son...@gmail.com wrote:
Can i make only base backup from temporary master to main master?
You didn't say which version of PostgreSQL you're using, what OS
it's running on, how you're managing the replication, or what
exactly you did -- so it's hard to give very specific advice. That
Hi,
I need a help on restoring backup which was taken under a linux machine with
the below command
pg_dump mydb /myhome/backup/mydb_backup.pgdump
now I want to restore the backup (my_db_backup.pgdume) file under my windows
machine can any one kindly explain me the process to restore this.
I
On Thu, Mar 31, 2011 at 3:37 PM, Anal Dey anal@gmail.com wrote:
I need a help on restoring backup which was taken under a linux machine
with
the below command
pg_dump mydb /myhome/backup/mydb_backup.pgdump
now I want to restore the backup (my_db_backup.pgdume) file under my
windows
On 2010-12-14, gosta100 stathisgot...@hotmail.com wrote:
Hello everyone,
I have a copy of the data folder of a Windows postgres installation. Is
it possible to restore the databases contained in there to another postgres
server?
yes, you'll need to correct the permissions on the files
Hello everyone,
I have a copy of the data folder of a Windows postgres installation. Is
it possible to restore the databases contained in there to another postgres
server?
Thank you.
--
View this message in context:
Yes, it is. Have a look at pg_dump utility. The documentation contains
plenty of examples.
On Tue, Dec 14, 2010 at 12:14 PM, gosta100 stathisgot...@hotmail.comwrote:
Hello everyone,
I have a copy of the data folder of a Windows postgres installation. Is
it possible to restore the
Hi gurus,
When I try to
pg_restore -d teste -v -j 16 teste.dmp 2 teste.log
I give error:
pg_restore: opção inválida -- j
Tente pg_restore --help para obter mais informação.
How can using parallel resource in new postgres?
Regards
Paulo
paulo matadr saddon...@yahoo.com.br wrote:
When I try to
pg_restore -d teste -v -j 16 teste.dmp 2 teste.log
I give error
What do you get from?:
pg_restore --version
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
Hi,
I have problem to restore my dump. I have generated my dump from sun
solaris platform and I want start restore on linux platform. My dump
contains postgis and pgrouting tables.
I create dump using this command:
pg_dump my_db my_dump.dump
I restore my dump using this command:
createdb
Hi,
Il 02/12/10 20:04, Luca Santaniello ha scritto:
I have problem to restore my dump. I have generated my dump from sun
solaris platform and I want start restore on linux platform. My dump
contains postgis and pgrouting tables.
Are you using the same versions of PostgreSQL and PostGIS or did
During restore of a database (from a full backup), the general practice is to
rebuild the indexes. I think with pg_dump and pg_restore (or psql restore), the
only option is to rebuild the indexes. Am I right or is it possible to backup
indexes as well and restore them ?
Just exploring, to
A J s5...@yahoo.com wrote:
I think with pg_dump and pg_restore (or psql restore), the only
option is to rebuild the indexes. Am I right or is it possible to
backup indexes as well and restore them ?
With pg_dump it is copying in rows by value, so indexes must then be
built. If you use
Hi All,
Is there an easy way to restore to a new table where the column name
have been changed but data remains the same?
For example I am trying to restore from existing system, table1(col1)
to table1(col2) and it is erroring out on the new column name even
though it is a data only
Dinesh Bhandary dbhand...@iii.com wrote:
Is there an easy way to restore to a new table where the column
name have been changed but data remains the same?
Restore to the old name and then rename the column?
Access the backup file and change the COPY statement to the new
column name?
If
There are a couple of ways. Assuming that it's the same database, and it's up
and running, you could do this:
Assuming:
table foo (col1 text, col2 int);
table bar (col2 text, col3 int);
insert into bar (select * from foo);
would stick everything from foo.col1 and foo.col2 into bar.col2
Awesome, this will work. It won't retain the column name in insert
into statement. I was not sure if this will work with postgres 8.2.5 but
it does.
Thanks.
Dinesh
On 10/5/2010 11:15 AM, Kevin Grittner wrote:
Dinesh Bhandarydbhand...@iii.com wrote:
Is there an easy way to restore to a
On 10/5/10 11:08 AM, Dinesh Bhandary wrote:
Hi All,
Is there an easy way to restore to a new table where the column name have been
changed but data remains the same?
For example I am trying to restore from existing system, table1(col1) to
table1(col2) and it is erroring out on the new column
Reading this thread confuses me a little bit. There is no need to backup
a cluster in order to move it to another disk within the same machine.
Stopping the Database, moving $PGDATA, adjusting scripts and routines if
nessecary and firing up the whole thing would do fine.
regards
-Andreas
Good day all,
I am fairly new with PQSQL and am slowly picking things up - I have added a new
disk and would like to do two things:
1. Restore a backup to this new disk - /hda2/pgdata/
2. Move a database from /hda1/pgdata to /hda2/pgdata/
Any help is most appreciated, thank you.
a f just1co...@yahoo.ca wrote:
I have added a new disk and would like to do two things:
1. Restore a backup to this new disk - /hda2/pgdata/
2. Move a database from /hda1/pgdata to /hda2/pgdata/
First I want to be clear about whether you want to restore and move
entire database
kevin.gritt...@wicourts.gov
To: pgsql-admin@postgresql.org; a f just1co...@yahoo.ca
Sent: Thu, July 22, 2010 12:52:59 PM
Subject: Re: [ADMIN] Restore a backup to a different disk?
a f just1co...@yahoo.ca wrote:
I have added a new disk and would like to do two things:
1. Restore a backup
a f just1co...@yahoo.ca wrote:
No cluster here, it is just a stand alone db server.
There's some terminology you've apparently not grasped yet -- when
PostgreSQL is running, the instance of the server is referred to as
a cluster. If you're running a PostgreSQL database server, you
are
but #1 was focused on backing up MyDatabase that resides on
/hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.
Do you already have the backup you want to restore? If so, how was
it made, exactly?
Yes.
I used pg_dump to make the backup.
a f just1co...@yahoo.ca wrote:
but #1 was focused on backing up MyDatabase that resides on
/hda1/pgdata, and restore it as MyDatabase2 on /hda2/pgdata.
Do you already have the backup you want to restore? If so, how
was it made, exactly?
Yes.
I used pg_dump to make the backup.
Hi all,
Today, I tried to recover a postgresql cluster (pitr). I think it went
fine (although I'm not sure), but I got some warnings afterwards...
2010-07-15 23:01:48 CEST [22907]: [2-1] user=,db= LOG: starting
archive recovery
2010-07-15 23:01:48 CEST [22907]: [3-1] user=,db= LOG:
2010/6/2 ALEXANDER JOSE aang...@hotmail.com
psql coon I'm trying to restore a database that has 60 GB in size, where
there is a table with 38 million records, has raised 18 million records when
the restore process fails on a syntax error, the backup was made with a
file. sql as the best way
hi,
sounds like a plain text backup. your problem, I guess, will be some
constraint issue. I suggest commenting out the constraints in the backup
file before running the restore.
regards
andreas
ALEXANDER JOSE wrote:
psql coon I'm trying to restore a database that has 60 GB in size,
On Tue, Jun 1, 2010 at 9:26 PM, ALEXANDER JOSE aang...@hotmail.com wrote:
psql coon I'm trying to restore a database that has 60 GB in size, where
there is a table with 38 million records, has raised 18 million records when
the restore process fails on a syntax error, the backup was made
psql coon I'm trying to restore a database
that has 60 GB in size, where there is a table with 38 million records,
has raised 18 million records when the restore process fails on a
syntax error, the backup was made with a file. sql as the best way I can do
to restore??
Alexander Angel
I have a question, I
have postgres 8.2.5 on a windows server on another machine and I have
suse linux enterprise 10 postgres 8.4, you perform a backup with pgadmin
1.10 to a database and restore the database in the version of postgres 8.4
gave me many errors that could not find some
Dear all,
I would like to know if it is possible to restore data to a pre-populated
db/table.
I was reading the man pages for pg_dump and pg_restore.
The limitations of pg_restore are detailed below.
* When restoring data to a pre-existing table and the option...
Does that mean the
Renato Oliveira renato.olive...@grant.co.uk wrote:
I would like to know if it is possible to restore data to a
pre-populated db/table.
Yes.
Does that mean the table can exist and can be populated with
data, pg_restore will append the data to the db/table without
deleting/dropping the
On Thu, Jan 28, 2010 at 4:26 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
I'm still not sure I follow, but there's a technique which isn't
worth much for backup proper, but can be a good way to repeatedly
get to a consistent starting point for tests in some circumstances.
Look at
dev.pho dev@gmail.com wrote:
I was wondering if I could restore the database from the location
of the tablespace.
It's not clear exactly what you want to do. Have you read through
the documentation on backup and restore?:
http://www.postgresql.org/docs/8.4/interactive/backup.html
On Thu, Jan 28, 2010 at 9:56 AM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
dev.pho dev@gmail.com wrote:
I was wondering if I could restore the database from the location
of the tablespace.
It's not clear exactly what you want to do. Have you read through
the documentation on
Greg Spiegelberg gspiegelb...@gmail.com wrote:
I don't know if this was the intent but it did provide me with
what I thought was a good idea.
* Snapshot a schema / tablespace / database to another schema /
tablespace / database.
The applications for this could be
* an alternative to
Hello,
I was wondering if I could restore the database from the location of the
tablespace.
If yes, how can I do this.
Thanks in advance,
Dev.
Le mercredi 2 décembre 2009 à 07:34:09, Brian Myers a écrit :
Hi all,
I'm trying to restore an old backup (7.1.4) into a new PG database (8.4).
There are errors with some of the RI and sequences, but those are easy to
fix.
The problem is that one table in the DB has TEXT fields in it
Hi all,
I'm trying to restore an old backup (7.1.4) into a new PG database (8.4). There
are errors with some of the RI and sequences, but those are easy to fix.
The problem is that one table in the DB has TEXT fields in it and these seem to
be sensitive to the DB encoding. The default in the
I try to restore a backup from 8.4 to 8.3 version but I got a error. Is
possible to do this?
Thanks..
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi All
In postgres-sql,
Can we do a dependent tables restore when i restore one table? (dependent
tables means tables which are linked (foreign key references))
Can I get the dependent triggers of a table when i restore a table?
Can I get the dependent functions of the trigger when i restore
--- On Wed, 3/12/08, Marc Fromm [EMAIL PROTECTED] wrote:
From: Marc Fromm [EMAIL PROTECTED]
Subject: [ADMIN] restore a table in a database
To: pgsql-admin@postgresql.org pgsql-admin@postgresql.org
Date: Wednesday, 3 December, 2008, 7:21 PM
How do I restore just a table to a database? I
: Re: [ADMIN] restore a table in a database
--- On Wed, 3/12/08, Marc Fromm [EMAIL PROTECTED] wrote:
From: Marc Fromm [EMAIL PROTECTED]
Subject: [ADMIN] restore a table in a database
To: pgsql-admin@postgresql.org pgsql-admin@postgresql.org
Date: Wednesday, 3 December, 2008, 7:21 PM
How do I
How do I restore just a table to a database? I was able to create a backup of
the required table from a backup of the database as follows.
I don't know how to properly restore the backed up table departments to the
original sms database.
create a new db
createdb -U postgres smstest
restore a
I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
thing.
I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
4-core, 4gb machine. postgresql appears to be installed and
Anony Mous [EMAIL PROTECTED] writes:
I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
thing.
I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
4-core, 4gb machine.
Dear Support!
I speak English not well, sorry.
I use Postgresql 8.3.0 on Win32. So, when I try to restore into database, I
have an error such as
2008-08-05 12:07:33 MSD ERROR: could not load library C:/Program
Files/PostgreSQL/8.3/lib/pldbgapi.dll: unknown error 126
2008-08-05 12:07:33 MSD
Does anyone have some insight on why the db size is expanding with each restore?
If I restore all the postgresql databases from pg_dumpall and use the -c to
drop databases before restoring them the size of the base directory
dramatically increases with each restore (193MB to 355MB to 624MB). If
Marc Fromm [EMAIL PROTECTED] writes:
Does anyone have some insight on why the db size is expanding with each
restore?
If I restore all the postgresql databases from pg_dumpall and use the -c to
drop databases before restoring them the size of the base directory
dramatically increases with
On Fri, Jun 13, 2008 at 3:33 AM, [EMAIL PROTECTED] wrote:
Hi,
Is it possible to restore a backup schema to another schema ?
For instance I create a backup of a database called source with its public
schema with pg_backup
I want to restore this backup in a database called dest into a new
Hi,
Is it possible to restore a backup schema to another schema ?
For instance I create a backup of a database called source with its public
schema with pg_backup
I want to restore this backup in a database called dest into a new schema
called public2
Thanks a lot for your reply,
Thierry
On a newly created server I stupidly restored over the top of the
postgres system database using the GUI...(postgresql n00b) and am
wondering a couple of things.
Firstly, if this database is overwritten, is it detrimental to the
running of PostgreSQL?
Secondly is it just a simple
[EMAIL PROTECTED] wrote:
i have a backup of data folder of my old postgresql database on 7.54
now i want to restore my complete database from data folder in ver 8.1
I assume you mean you wish to upgrade your 7.4 installation of
PostgreSQL to PostgreSQL 8.1 ?
The short answer:
You'll need
To be more clear it was the 'postgres' database.
Regards,
Patrick
-Original Message-
From: Phillip Smith [mailto:[EMAIL PROTECTED]
Sent: Monday, 5 May 2008 4:22 PM
To: Patrick Roberts; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] restore postgres system database 8.1.11
On a newly
Hi All,
On a newly created server I stupidly restored over the top of the
postgres system database using the GUI...(postgresql n00b) and am
wondering a couple of things.
Firstly, if this database is overwritten, is it detrimental to the
running of PostgreSQL?
Secondly is it just a
hi alli have a backup of data folder of my old postgresql
database on 7.54now i want to restore my complete database
from data folder in ver 8.1so can any gurus give me the idea
about itYogeshSenior Officer (System)
--
This message has been scanned for viruses and
dangerous content by
i have restore my old data folder in pgsql
but still there is a permission problem
Can you give us any more info? Specific error messages?
In general, permissions should be (I think):
chown -R postgres:postgres /path/to/data
find /path/to/data -type -d -print | xargs chmod 700
Hi all i have restore my old data folder in pgsqlbut
still there is a permission problemSo how can i restore
my complete data from the data folderYogesh
--
This message has been scanned for viruses and
dangerous content by
BanasDairy(Amul), and is
believed to be clean.
I am backing up my databases with pgdump -c command to prevent duplicate
records during a restore.
When I restore the database with this command:
psql -U postgres infoserv /tmp/infoserv-03-25-2008_12-10
I get the message to use cascade to drop dependent objects.
DROP TABLE
ERROR:
When restoring from a pg_dumpall file, is it best to delete the contents
of the data folder, run intitdb to recreate it, and then do the command
psql -U postgres -f backupfile postgres?
When I do the restore over top of what is in the data folder already,
there are many errors reported.
Thanks
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
I must be blind or something but it seems I just can't
figure out a working procedure to restore a PG dump in
custom format (created with pg_dump -Fc) into several
different PG databases with different owners (i.e. for
testing purposes)
I want
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Just a short followup...
Andreas Haumer schrieb:
Hi!
I must be blind or something but it seems I just can't
figure out a working procedure to restore a PG dump in
custom format (created with pg_dump -Fc) into several
different PG
Andreas Haumer [EMAIL PROTECTED] writes:
I now solved it by temporarily adding the superuser privilege
to the roles in question.
That should not be necessary, unless the dump contained objects that
require superuser permission to create (such as C-language functions)
--- in which case giving
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Tom!
Thanks for your reply!
Tom Lane schrieb:
Andreas Haumer [EMAIL PROTECTED] writes:
I now solved it by temporarily adding the superuser privilege
to the roles in question.
That should not be necessary, unless the dump contained objects
Hey Guys,
This is my first email to list. Hope i will get the solution quickly.
I am working on postgresql 8.1
I have a DB, with mre than 4 schemas. I want to take backup of one of the
schema and restore the same schema into another DB .ofcourse schema names
are same.
I am able to take
On 1/23/07, Kranti [EMAIL PROTECTED] wrote:
Hey Guys,
This is my first email to list. Hope i will get the solution quickly.
Hi,
please use pg_dump -n option to select schema. Read manual
pages of pg_dump.I am not sure how to do it in pgadminIII
all said it is doable.
regds
malah.
I am
Sorry insist in this question, but did someone try to restore and
recover the database, and check if no data is lost??
I tryed to do some steps following the Postgres documentation, but ... I
couldn't recover.
Anybody has some tips or suggestion?
Thanks in advance.
I followed the steps
Did you have your archive_command configured before you started this
test (before starting the db?)...
also did the tx_logs actually get saved? It looks to me that you don't
have any valid archives. Also somewhat suspicious that it's starting
with serial 1 for the transaction log -- which
I need to test and create a procedure to restore databases.
I followed the steps based on the site, but I couldn't finish succesfully.
I did:
1. Put the database on Backup Mode and copy datafiles.
/pg/bin/psql cresoldev -c SELECT pg_start_backup('/pg/backup/');
tar -cvf
Yes!
I followed exactly that page to do.
Thanks
Scott Marlowe escreveu:
On Wed, 2006-07-12 at 15:04, Alexander Burbello wrote:
Ok! Its a good tool, but for Production Database I think it is not
recommended.
Only using pg_dump for the second backup plain.
Suppose that you backed up at
Ok! Its a good tool, but for Production Database I think it is not
recommended.
Only using pg_dump for the second backup plain.
Suppose that you backed up at 6:00am and at 9am happened a crash on the
server.
In this case, I would lost data between that time, 3 hours of information.
For
On Wed, 2006-07-12 at 15:04, Alexander Burbello wrote:
Ok! Its a good tool, but for Production Database I think it is not
recommended.
Only using pg_dump for the second backup plain.
Suppose that you backed up at 6:00am and at 9am happened a crash on the
server.
In this case, I would lost
On 7/11/06, Burbello [EMAIL PROTECTED] wrote:
I need to test and create a procedure to restoredatabases.Why not just use pg_dump?See http://manual.intl.indoglobal.com/ch06s07.html
- it's really easy. This is how we copy from production to testing and development and how we do nightly backups.
On May 24, 2006, at 2:56 PM, Todd A. Cook wrote:
Tom Lane wrote:
Todd A. Cook [EMAIL PROTECTED] writes:
I have found that increasing maintenance_work_mem can decrease index
build speed on large tables:
You should probably re-measure when 8.2 comes out; we've fixed a
number
of performance
Hi,
I'm currently restoring a fairly large DB from a pg_dump and it's taking
about 12 hours to finish. The main part of this time is spent creating
indexes. Is there anyway I can speed up the restore process, or do i just
have to wait? I'm using postgres 8.1.3 on freebsd and the pg_dump is
Ruairi [EMAIL PROTECTED] writes:
I'm currently restoring a fairly large DB from a pg_dump and it's taking
about 12 hours to finish. The main part of this time is spent creating
indexes. Is there anyway I can speed up the restore process, or do i just
have to wait?
There's not much you can
Title: RE: [ADMIN] Restore of pg_dump taking a long time...
I have found that the following steps have increased the speed of my restores:
1. dropdb DBNAME
2. createdb DBANME
3. Increase maintenance_work_mem as Tom mentioned. I do this at restore/runtime
4. Increase work_mem as Tom mentioned
On Wed, 2006-05-24 at 13:56, mcelroy, tim wrote:
I have found that the following steps have increased the speed of my
restores:
1. dropdb DBNAME
2. createdb DBANME
3. Increase maintenance_work_mem as Tom mentioned. I do this at
restore/runtime
4. Increase work_mem as Tom mentioned. I do
Todd A. Cook [EMAIL PROTECTED] writes:
I have found that increasing maintenance_work_mem can decrease index
build speed on large tables:
You should probably re-measure when 8.2 comes out; we've fixed a number
of performance issues in the sorting code that might cause that.
Tom Lane wrote:
Todd A. Cook [EMAIL PROTECTED] writes:
I have found that increasing maintenance_work_mem can decrease index
build speed on large tables:
You should probably re-measure when 8.2 comes out; we've fixed a number
of performance issues in the sorting code that might cause that.
I would typically drop the indicies before taking the dump, and recreate
in the new instance. I know the loads go alot faster that way. Perhaps
the index creation would be the same.
Tom Lane wrote:
Ruairi [EMAIL PROTECTED] writes:
I'm currently restoring a fairly large DB from a pg_dump and
1 - 100 of 162 matches
Mail list logo