On Sun, Nov 04, 2007 at 03:52:51PM -0500, Jesus Arocho wrote:
Ok, I committed the worst mistake in db admin. I upgraded to 8.1 on my
debian
server but forgot to backup one of the databases. The 7.1 directory is still
there. I would like a list of options. I am not sure that temporarily
On Sun, Nov 04, 2007 at 03:52:51PM -0500, Jesus Arocho wrote:
Ok, I committed the worst mistake in db admin. I upgraded to 8.1 on my
debian
server but forgot to backup one of the databases. The 7.1 directory is still
there. I would like a list of options. I am not sure that temporarily
Ok, I committed the worst mistake in db admin. I upgraded to 8.1 on my debian
server but forgot to backup one of the databases. The 7.1 directory is still
there. I would like a list of options. I am not sure that temporarily
reinstalling 7.1 will allow access immediately or must I have to
On 04/11/2007 20:52, Jesus Arocho wrote:
Ok, I committed the worst mistake in db admin. I upgraded to 8.1 on my debian
server but forgot to backup one of the databases. The 7.1 directory is still
there. I would like a list of options. I am not sure that temporarily
reinstalling 7.1 will
Help needed to restore a backup database!
1. Postgres service was started. When I run a restore command for the backup stored in /tmp (backed from another server working on this database and sent to meby email by another user). I created a database by the same name royapuram by using createdb
adccs wrote:
Help needed to restore a backup database!
1. Postgres service was started. When I run a restore command for the
backup stored in /tmp (backed from another server working on this
database and sent to meby email by another user). I created a database
by the same name royapuram by
Richard Huxton dev@archonet.com writes:
adccs wrote:
[EMAIL PROTECTED] ~]# /usr/bin/pg_restore -a /tmp/royapuram.backup
ERROR: pg_restore: [archiver] unsupported version (1.10) in file header
Your user probably has a more recent version of PostgreSQL than you do,
so pg_restore can't
I am trying to restore a large database and use the commond
cat dumpfilename | psql dbname
I got a out of memory error when it is trying to copy a String with size
of 245,000,000
Can anyone shed some light on it? Thanks for your help,
wenyan
---(end of
Wenyan Ji wrote:
I am trying to restore a large database and use the commond
cat dumpfilename | psql dbname
I got a out of memory error when it is trying to copy a String with size
of 245,000,000
Can anyone shed some light on it? Thanks for your help,
Why are you using cat rather than