Re: [ADMIN] [Fwd: [Zope-dev] Authentication Problem with Postgres]

2001-11-26 Thread Andre Schubert
Tom Lane schrieb: > > Andre Schubert <[EMAIL PROTECTED]> writes: > > sometimes i have a curios problem with my Zope. > > My sysop has traced the protcols before and after the error. > > Zope sends some data and then a crypted password with the salt. > > If the error is occured the password that Z

[ADMIN] windoze accesse to pg backend

2001-11-26 Thread David Bear
I am wondering what 'common' solutions are used to access postgress data on unix back ends. I'd be glad to tabulate results for the list, but don't even know all the options. I am thinking of MS-Access Paradox Excel Brio Other tools ODBC other Note, that I don't know

[ADMIN] installing 7.2b3 on IRIX 6.5.13

2001-11-26 Thread Luis Amigo
We needed to install 7.2b3 on Irix 6.5.13 with MIPSpro Compilers: Version 7.30 when installing as we installed 7.1.3, it is with-template=irix5 adding to irix5 these lines: CC=cc CFLAGS='-n32 -O2 -r12000' LDFLAGS='-n32 -O2 -r12000' where -o2: Turns on exten

Re: [ADMIN] Issues with pg_dump & pg_restore

2001-11-26 Thread Tom Lane
"Lane Rollins" <[EMAIL PROTECTED]> writes: > It runs find until the "Create table for BLOBS xrefs" then it slowly > starts eating up all available memory. It eventually gets killed due to > no more memory. The system has 512Mb of memory + 128Mb of swap. The data > base has about 500,000 entries in

Re: [ADMIN] table permissions

2001-11-26 Thread Chad R. Larson
At 10:39 AM 11/22/01 +, MG wrote: >How can I query (in SQL) the user permissions of a table? Which system table >stores the tables permissions for the user? select * from pg_user ; -crl -- Chad R. Larson (CRL22)[EMAIL PROTECTED] Eldorado Computing, Inc. 602-604-3100

Re: [ADMIN] Problems between Mandrake and pg

2001-11-26 Thread Chad R. Larson
At 02:44 PM 11/21/01 +0100, Ryan Rohde Hansen wrote: It is true, that we do not have the -i option on, but we haven't found a way to change it that really works. You MUST have the -i switch set, or else you can only make connections to the database from the machine it run on. Attached are two scr

Re: [ADMIN] table permissions

2001-11-26 Thread Ian Barwick
On Thursday 22 November 2001 11:39, MG wrote: > Hi! > > I subscribe to this list now. :) I have a question. > How can I query (in SQL) the user permissions of a table? Which system > table stores the tables permissions for the user? Sounds like you are looking for pg_class, column relacl. See: h

Re: [ADMIN] table permissions

2001-11-26 Thread Ian Barwick
On Thursday 22 November 2001 11:39, MG wrote: > Hi! > > I subscribe to this list now. :) I have a question. > How can I query (in SQL) the user permissions of a table? Which system > table stores the tables permissions for the user? Sounds like you are looking for table pg_class, column relacl. S

[ADMIN]

2001-11-26 Thread rkollmorgen
Hallo I tried to compile postgresql-7.1.2 on SunOS 5.8 with gcc and Suns cc. I made the following: # ./configure --prefix=/usr/local/ loading cache ./config.cache checking host system type... sparc-sun-solaris2.8 checking which template to use... solaris checking whether to build with locale sup

[ADMIN] Issues with pg_dump & pg_restore

2001-11-26 Thread Lane Rollins
I'm trying to make a copy of a production database that's running on a RedHat 7.0 machines with posgresql 7.1.2 and moving it to a machine running RedHat 7.1 with postgresql 7.1.3. The database has blobs so I first tried pg_dump -Ft -b docarc >docarc.tar That failed with Archiver(tar) could n

Re: [ADMIN] windoze accesse to pg backend

2001-11-26 Thread David Stanaway
On Tuesday, November 27, 2001, at 03:25 AM, David Bear wrote: > > I am wondering what 'common' solutions are used to access postgress data > on unix back ends. There is an ODBC driver on the postgres website which works quite well for me with Access for people in the office on Windows workst

Re: [ADMIN] table permissions

2001-11-26 Thread Andrew G. Hammond
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2001 November 22 05:39 am, MG wrote: > I subscribe to this list now. :) I have a question. > How can I query (in SQL) the user permissions of a table? Which system > table stores the tables permissions for the user? psql -E test \dp displays the