* 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
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
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
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.
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.
[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
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 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
thanks that was in the doc ! indeed I needed to put "local ezpublish_db
ezpublish trust" before other rules , as the first rule that match end
the reading of pg_hba.conf .
Thanks again .
Ben Kim wrote:
psql: FATAL: IDENT authentication failed for user "ezpublish"
This might help, o
>psql: FATAL: IDENT authentication failed for user "ezpublish"
This might help, or you may want to check or post your pg_hba.conf.
http://archives.postgresql.org/pgsql-sql/2004-03/msg00202.php
(or
http://www.postgresql.org/docs/7.4/interactive/auth-methods.html#AUTH-IDENT)
HTH,
Ben Kim / Dev
Ben Kim wrote:
ezpublish_db-# ALTER USER ezpublish SET PASSWORD secret;
ERROR: syntax error at or near "$" at character 1
I wonder why you have "ezpublish_db-#" instead of "ezpublish_db=#"? I just
noticed it, and to me it happens usually when something's been carried
over from the previ
>ezpublish_db-# ALTER USER ezpublish SET PASSWORD secret;
>ERROR: syntax error at or near "$" at character 1
I wonder why you have "ezpublish_db-#" instead of "ezpublish_db=#"? I just
noticed it, and to me it happens usually when something's been carried
over from the previous line. My 2 pence.
very good, that worked fine :-)
I restored the files from tar, started a postgresql 7.3 on an old redhat
9 ! pg_dump my database, psql it back to my postgresql 7.4 on my
production RHEL4 server .
still a small pb, I seem to have lost authentification. (although
pg_hba.conf was restore also)
Hi,
try this:
psql -t -d yourdb -c "SELECT datid FROM pg_stat_database WHERE
datname='yourdb';"
http://www.postgresql.org/docs/8.0/static/monitoring-stats.html
Greetings,
Martin
Am Donnerstag, den 30.06.2005, 12:57 +0200 schrieb jehan-free:
> OK, I'am not yet at restarting postgres .. but if a
OK, I'am not yet at restarting postgres .. but if at get pb then I check
that , thanks !
For now , How can I tell from the bare file the mapping between a
database name and the number appearing in /var/lib/pgsql/base directory
I have :
pgsql/data/base/1/
pgsql/data/base/16975/
pgsql/data/base/16
Hi
Maybe you must reset the WAL's
( http://www.postgresql.org/docs/7.3/interactive/app-pgresetxlog.html )
after restoring from tarball if postgres doesn't start.
Am Donnerstag, den 30.06.2005, 07:34 +0200 schrieb jehan:
> So I must one way or another run a 7.3, restore the file from the
> tarbal
e junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] restore database from bare files
jehan procaccia wrote:
However I do have a tar file of the filesystem , it was on a RHEL 3
with rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq
will
7.3.9 doesn't
need to dump and restore of databases)
greeting.
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Peter Eisentraut
Enviado el: miércoles, 29 de junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] restor
jehan procaccia wrote:
> However I do have a tar file of the filesystem , it was on a RHEL 3
> with rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq
> will just restoring the whole directory /var/lib/pgsql will suffices
Assuming that you made the tarball when the server was shut dow
hello,
I crashed my server, and I didn't took the precaution to pg_dump one of
my database :-(
However I do have a tar file of the filesystem , it was on a RHEL 3 with
rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq
will just restoring the whole directory /var/lib/pgsql will suf
38 matches
Mail list logo
