On 5/4/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Mike Frysinger" <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] 0 ~]$ psql -d gforge5 -f gforge.schema
> ...
> psql:gforge.schema:31: ERROR: could not access file
> "$libdir/tsearch2": No such file or
On 5/4/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Well, I loaded and dumped and reloaded this schema in 8.1 without any
problem, so I'm still baffled.
oh, and the machine that i created the dump on and the machine i
loaded the dump on are both Fedora Core 6 that report:
$ postgres --version
postgr
On 5/4/07, Tom Lane <[EMAIL PROTECTED]> wrote:
There are several obvious things wrong with that (eg, psql cannot read
-Fc format dumps) so I suppose it's an editorialization on what you
really typed.
right, what i posted was a typo, what i ran did not have the -Fc
Perhaps the problem is hidde
On 4/20/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Hmph. It should pretty much just work ... and there is *definitely* not
any update command visible in the source code.
i dug deeper (like i should have in the first place) and the UPDATEs
are ok ... they're inside of functions which get triggered
On 4/20/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Mike Frysinger" <[EMAIL PROTECTED]> writes:
> i was experimenting with using pg_dump/pg_restore and pg_dump/psql ...
> when using psql to import, i didnt use -Fc ... but the errors were the
> same regardless of wh
On 4/20/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Mike Frysinger" <[EMAIL PROTECTED]> writes:
> $ pg_dump -F c -s -d database-server mydb > mydb.schema
> $ psql -d mydb < mydb.schema
>
pg_dump -Fc does not produce a file that psql can read directly.
Is t
i'm trying to add the ability to dump our database as a backup in case
things go wrong with the db server, and so i'm trying to test things
now so that if/when things do go bad, i'm not scrambling then :)
as a test, i'm just trying to dump a database's schema and restore
that ... but it seems lik
