On Nov 15, 2011 9:46 PM, "Brice André" wrote:
>
> Hello,
>
> I sometimes define some access rights on table columns instead of whole
table. Everything works fine except when I perform a dump.
>
> When I dump a databse that contains such access rights, the pg_dump
utility generates commands like th
Hello,
I sometimes define some access rights on table columns instead of whole
table. Everything works fine except when I perform a dump.
When I dump a databse that contains such access rights, the pg_dump utility
generates commands like this one :
GRANT SELECT("Login") ON TABLE "Clients" TO "Age
> mv camper.dump20020116 camper_bak/
>
> The error I get is ::
>
> mv: camper.dump20020116: Value too large for defined data type
>
It may not be a postgresql problem. It may be due to your filesystem. Try
the documentation or mailing list of your filesystem.
regards,
bhuvaneswaran
---
Rudi Starcevic wrote:
Hi,
After doing a pg_dump on a database I'm unable to access the file.
My command is simply 'mv' ::
mv camper.dump20020116 camper_bak/
The error I get is ::
mv: camper.dump20020116: Value too large for defined data type
Strange. It seems to be saying the file I created
Hi,
After doing a pg_dump on a database I'm unable to access the file.
My command is simply 'mv' ::
mv camper.dump20020116 camper_bak/
The error I get is ::
mv: camper.dump20020116: Value too large for defined data type
Strange. It seems to be saying the file I created is too large to handle.
Ed Loehr wrote:
>
> Graham Vickrage wrote:
> >
> > I am trying to backup a production database running on v6.5 and restore it
> > on our test machine running v6.5.
> >
> > The largest table has about 750,000 rows, the other 5 tables are very small
> > approx 100 rows.
> >
> > When I try to restor
Graham Vickrage wrote:
>
> I am trying to backup a production database running on v6.5 and restore it
> on our test machine running v6.5.
>
> The largest table has about 750,000 rows, the other 5 tables are very small
> approx 100 rows.
>
> When I try to restore the database using "psql -e dat
I am trying to backup a production database running on v6.5 and restore it
on our test machine running v6.5.
The largest table has about 750,000 rows, the other 5 tables are very small
approx 100 rows.
When I try to restore the database using "psql -e database < db.out" I get
the error message