>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 op
>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 databas
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 Pos
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.
Thanks!
于 2012/9/7 20:20, Sergey Konoplev 写道:
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter 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
On Fri, Sep 7, 2012 at 9:44 AM, Rural Hunter 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 restore?
Unpack bas
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. Is
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 spe
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 spe
On Fri, Sep 16, 2011 at 3:27 AM, marvin.deoliveira
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 any impact on performanc
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:
http://post
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 message
On Thu, Sep 15, 2011 at 4:12 PM, marvin.deoliveira
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
> --disable-triggers -v
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/.sql -d
The pg_restore shows:
pg_restore: disabling triggers fo
On Thu, Sep 15, 2011 at 3:32 PM, marvin.deoliveira
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 drop the indexes it will h
* 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 ha
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
0001
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 backu
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
sonnix 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
said, I'm pretty
Hi,
i have master and slave server(timeline 1). I turned off master and set up
slave to new temporary master and it has enabled wal archiving (timeline 2).
While the main master was turned off i had some insert to temporary master.
I need to recovery this inserts to main master from wal logs. When
On Thu, Mar 31, 2011 at 3:37 PM, Anal Dey 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
> machine
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 2010-12-14, gosta100 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 and run copy them
onto
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 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
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:
http://postgresql.1045698.n5.nabble.com/restore-database-files-tp3305210p33
paulo matadr 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:
http://www.postg
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
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 y
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
A J 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 PITR backups, it
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 figure
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 n
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 Bhandary wrote:
Is there an easy way to restore to a new table where the
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 and
Dinesh Bhandary 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 you can redo the
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 restore.
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
a f 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.
Well, if
>> 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 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 running a cluster, in t
To: pgsql-admin@postgresql.org; a f
Sent: Thu, July 22, 2010 12:52:59 PM
Subject: Re: [ADMIN] Restore a backup to a different disk?
a f 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 databas
a f 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 *clusters*, or whether you
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.
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:
rest
On Tue, Jun 1, 2010 at 9:26 PM, ALEXANDER JOSE 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 with a
> file. sql a
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,
wher
2010/6/2 ALEXANDER JOSE
> 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 res
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
Perform a backup
with the following command;
pg_dumpall-Upostgres
and record it in a file called respaldo.sql
postgres in my instance I have 22 databases, I wondered if the
above command I have supported all my databases and I use another
command.
___
On Wed, May 19, 2010 at 16:25, ALEXANDER JOSE wrote:
> 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.
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 functions.
Renato Oliveira 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 existing data?
Unless y
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 t
On Thu, Jan 28, 2010 at 4:26 PM, Kevin Grittner
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 CREATE DATABASE x WITH TEM
Greg Spiegelberg 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 the existing backu
On Thu, Jan 28, 2010 at 9:56 AM, Kevin Grittner
wrote:
> "dev.pho" 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?:
I don't know i
"dev.pho" 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
Perhaps you want
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
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 da
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 th
n@postgresql.org; Marc Fromm
Subject: 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"
> Date
--- 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"
> Date: Wednesday, 3 December, 2008, 7:21 PM
> How do I restore just a table
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
"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 m
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 work
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
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
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
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
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,
Thierr
Patrick Roberts wrote:
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?
T
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.
[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 t
> 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
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 si
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
BanasDairy
> 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: cann
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
Andreas Haumer <[EMAIL PROTECTED]> writes:
> Tom Lane schrieb:
>> Exactly what problems did you have using "-O -U user" ?
> So, the main problem is the call to
> CREATE PROCEDURAL LANGUAGE plpgsql;
> on the "mwdb" schema which contains all the tables, functions etc.
Right. As of 8.3, the default
-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
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 givi
-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 d
-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
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 wor
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 backup
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 wo
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 ba
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 /pg/backup/bk_
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 6:
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
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 product
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. =
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 /pg/backup/bk_b
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 performanc
Tom Lane wrote:
There's not much you can do to improve the performance of a restore
already in progress. Next time you might want to think about kicking up
maintenance_work_mem before you start it; that's about the only thing
you can really do to speed up index builds.
I have found that incre
1 - 100 of 181 matches
Mail list logo
