Обсуждение: dump problems:

    pg_dump seems to be getting a little confused on ACLs, look at this:

REVOKE ALL on "cat" from PUBLIC;
GRANT ALL on "nobody" to "nobody";

    For everything that has any differing priveleges, it does the same
grant (which, of course, doesn't work).

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________

6.4 doesn't seem to get along with FreeBSD 3.0-RELEASE well - if at
all.

In particular, some regression tests failed that I wouldn't expect to
- int8, sanity_check, trigers, misc, alter_table - and trying to
create databases with schema from 6.3.2 causes the backed to exit
unexpectedly.

Yet FreeBSD is listed as one of the supported OS's.

Has anyone else gotten this combination to work? Is there something
outside of the install process that needs to happen to make it work?

    Thanx,
    <mike

>
>     pg_dump seems to be getting a little confused on ACLs, look at this:
>
> REVOKE ALL on "cat" from PUBLIC;
> GRANT ALL on "nobody" to "nobody";
>
>     For everything that has any differing priveleges, it does the same
> grant (which, of course, doesn't work).

What PostgreSQL version is this?  If it is not 6.4, I recommend an upgrade.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Mon, 9 Nov 1998, Bruce Momjian wrote:

    Yes, sorry, this is 6.4.

    Also, lo_import causes the backend to dump core.

    To enumerate, this database has made me extremely happy, 'cept for
the following problems I've found:

    * this dump problem
    * lo_import dumps core
    * SunOS 4.1.4 build won't communicate with my IRIX server (I
      haven't had time to figure out why)

    Seems like there might have been some other problem recently.  I
did have a couple build problems on SunOS and IRIX, and DBD::Pg broke.
Nothing too bad.  I'm *so* impressed with this new version.  :)

// >
// >     pg_dump seems to be getting a little confused on ACLs, look at this:
// >
// > REVOKE ALL on "cat" from PUBLIC;
// > GRANT ALL on "nobody" to "nobody";
// >
// >     For everything that has any differing priveleges, it does the same
// > grant (which, of course, doesn't work).
//
// What PostgreSQL version is this?  If it is not 6.4, I recommend an upgrade.
//
// --
//   Bruce Momjian                        |  http://www.op.net/~candle
//   maillist@candle.pha.pa.us            |  (610) 853-3000
//   +  If your life is a hard drive,     |  830 Blythe Avenue
//   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
//
//

--
SA, beyond.com                            The world is watching America,
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L________________________________________ and America is watching TV. __

>
>     pg_dump seems to be getting a little confused on ACLs, look at this:
>
> REVOKE ALL on "cat" from PUBLIC;
> GRANT ALL on "nobody" to "nobody";
>
>     For everything that has any differing priveleges, it does the same
> grant (which, of course, doesn't work).

I believe this has been fixed, and will be in 6.4.1 when we release it.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026