On Wed, 18 Jun 2008, Andrew Sullivan wrote:
Did you use a non-ascii dump format? Try
Andrew,
Not by design.
psql -U postgres -f pg814data.sql
Well! That stirred things up. I seem to have restored the accounting data
(and the other databases in the cluster), but cannot access them.
On Wed, Jun 18, 2008 at 10:42:51AM -0700, Rich Shepard wrote:
> [EMAIL PROTECTED] /usr4/postgres-backups]$ pg_restore -U postgres <
> pg814data.sql
> pg_restore: [archiver] input file does not appear to be a valid archive
>
> But it was created using the 8.3.3 pg_dumpall in /usr/bin/.
pgdumpal
On Wed, Jun 18, 2008 at 10:42:51AM -0700, Rich Shepard wrote:
> [EMAIL PROTECTED] /usr4/postgres-backups]$ pg_restore -U postgres <
> pg814data.sql
> pg_restore: [archiver] input file does not appear to be a valid archive
>
> But it was created using the 8.3.3 pg_dumpall in /usr/bin/.
Did you u
On Wed, 18 Jun 2008, Joshua D. Drake wrote:
You need to remove the directory, not the files underneath then:
Ah, so.
Redid, after removing /var/lib/pgsql/data
Then restore as normal using psql -U postgres < mydatabase.sql
Postgres is now running (whew!), but I'm still doing somethin
On Wed, 2008-06-18 at 10:23 -0700, Rich Shepard wrote:
> On Wed, 18 Jun 2008, Joshua D. Drake wrote:
> > Then you can reinitialize a new cluster with initdb here:
> > /var/lib/pgsql/data (you will have to remove the old one)
>
>As user postgres, I cleaned out /var/lib/pgsql/data/* and re-in
On Wed, 18 Jun 2008, Joshua D. Drake wrote:
This is what I suggest:
download 8.1.13:
unpack; then:
Done.
./configure --prefix=/tmp/pg813; make install
cd /tmp/pg813
bin/pg_ctl -D /usr4/pgsql_old/data start
cd /
/usr/bin/pg_dumpall -U > mydatabase.sql
Modified above a bit. I used /usr
On Wed, 2008-06-18 at 08:55 -0700, Rich Shepard wrote:
> On Wed, 18 Jun 2008, Andrew Sullivan wrote:
>
> > Can't do it. Start the old postmaster with -D /usr4/pgsql_old/data, and
> > then use pg_dumpall against that backend.
>
> Andrew,
>
>When I try, I see:
>
> [EMAIL PROTECTED]:/var/li
On Wed, 18 Jun 2008, Andrew Sullivan wrote:
Can't do it. Start the old postmaster with -D /usr4/pgsql_old/data, and
then use pg_dumpall against that backend.
Andrew,
When I try, I see:
[EMAIL PROTECTED]:/var/lib/pgsql$ postgres -D /usr4/pgsql_old/data
FATAL: database files are incompatib
On Wed, Jun 18, 2008 at 07:16:11AM -0700, Rich Shepard wrote:
> pg_dumpall from 8.3.3 to extract all data from the 8.1.4 version residing in
> /usr4/pgsql_old/data/ and write it to a file (with the -f option) in
> /usr4/postgres-backups.
Can't do it. Start the old postmaster with -D /usr4/pgsql_o
am Wed, dem 18.06.2008, um 7:16:11 -0700 mailte Rich Shepard folgendes:
> I do not see an option on the man page for pg_dumpall that directs it to
> the data of a different version on a different filesystem. I would greatly
> appreciate learning the correct syntax that will allow me to use the
On 18/06/2008 15:16, Rich Shepard wrote:
I do not see an option on the man page for pg_dumpall that directs it to
the data of a different version on a different filesystem. I would greatly
appreciate learning the correct syntax that will allow me to use the
pg_dumpall from 8.3.3 to extract all
11 matches
Mail list logo
