Re: [ADMIN] Re: few more securiry questions :-)

2000-06-01 Thread R D
Hi, > > 2.Why the authentication system is not integrated > in > > the system databases of pgSQL,like in MySQL for > > example? > > Because there's a bootstrapping problem: You would > have to connect to the > database to change the authentication settings, but > in order to connect > you have

Re: [ADMIN] Database/table limits ??????

2000-06-01 Thread Chris Albertson
I looked at the FAQ also and IMO the word "unlimited" is a bit unrealistic. "unlimited" means without limits. Come on now! Postgres DOES have limits on the size of a database or table. Very large limits but still limits. For example could I build a table with 100 billion rows? No I'd run out

Re: [ADMIN] Database/table limits ??????

2000-06-01 Thread Bruce Momjian
OK, but what do I put there? > > I looked at the FAQ also and IMO the word "unlimited" is a bit > unrealistic. "unlimited" means without limits. Come on now! > Postgres DOES have limits on the size of a database or table. > Very large limits but still limits. For example could I build > a tab

RE: [SQL] Re: [ADMIN] create view security

2000-06-01 Thread Wallingford, Ted
Hi Jan, Thanks for the insight, but can you tell me if the PostgreSQL ODBC driver for Windows works with PostgreSQL 7.0? thx, Ted _ Ted Wallingford Manager of Information Technology Independence Excavating, Inc. Precision Environmental Co. Indepen

Re: [ADMIN] Re: few more securiry questions :-)

2000-06-01 Thread Peter Eisentraut
Chris Albertson writes: > > > 2.Why the authentication system is not integrated in > > > the system databases of pgSQL,like in MySQL for > > > example? > > > > Because there's a bootstrapping problem: You would have to connect to the > > database to change the authentication settings, but in ord

Re: [ADMIN] Database/table limits ??????

2000-06-01 Thread Ohgaki Yasuo
I understand OID is signed integer which go up to 2^31. Almost any case it would be sufficient. (It's sufficient for me, at least) What I really want to know is the same as original poster. > > 8. Can a database be spread over more than one disk drive? > > 9. Can a table be spread over more tha

Re: [ADMIN] Database/table limits ??????

2000-06-01 Thread Bruce Momjian
[ Charset ISO-8859-1 unsupported, converting... ] > I understand OID is signed integer which go up to 2^31. > Almost any case it would be sufficient. (It's sufficient for me, at least) > > What I really want to know is the same as original poster. > > > > 8. Can a database be spread over more t

Re: [ADMIN] Database/table limits ??????

2000-06-01 Thread Ross J. Reedstrom
On Thu, Jun 01, 2000 at 09:30:01PM -0400, Bruce Momjian wrote: > [ Charset ISO-8859-1 unsupported, converting... ] > > I understand OID is signed integer which go up to 2^31. > > Almost any case it would be sufficient. (It's sufficient for me, at least) > > > > What I really want to know is the

Re: [ADMIN] pgsql 7 in alpha

2000-06-01 Thread Ryan Kirkpatrick
On 1 Jun 2000, LeSI wrote: > ive been compiling pgsql 7 in an alpha server (UP2000 / 2 cpus) > but , it stops there and few seconds later shows me an error of > spin.c stucked This is a known problem for the 6.5.x and 7.0 versions of PostgreSQL. You need to get a set of Linux/Alpha speci

[ADMIN] pg_dumpall: Message "failed sanity check, type with oid 155265 not found"

2000-06-01 Thread Werner Modenbach
I'm currently running PostgreSQL 6.5.1 and want to upgrade to 7.0. As adviced I ran pg_dumpall (V6.5.1) but I get the message server1:[pgsql] >pg_dumpall > db.out failed sanity check, type with oid 155265 was not found pg_dump failed on volleyball, exiting server1:[pgsql] > How can I solve this

[ADMIN] Postgresql 7.0.3 and php. Problem to install ?

2000-06-01 Thread Conti Alessandro (R_EDP)
I would like to install the new release of postgresql on my intranet. pgsql.so is compatible with the new release ? bye Alessandro

Re: [ADMIN] table size limit under Linux

2000-06-01 Thread Peter Eisentraut
On Wed, 31 May 2000, HENAFF Mari-mai FTRD/DMI/LAN wrote: > I read that postgres table size is unlimited. > But, a postgres table is stored into a file, and the size of a file is > limited to approximately 2 Giga Bytes under Linux. The table will be split into two (or more) files at gigabyte boun

Re: [ADMIN] pgaccess use wrong password

2000-06-01 Thread Peter Eisentraut
On Wed, 31 May 2000, Loïc TREGOUËT wrote: >Excuse me for the latest message , i've found the solution > > localallpasswordpasswdfile > > Now , passwords are stored (and crypted) in passwdfile . > The authentication with psql is ok > > But pgaccess still use the password in

[ADMIN] pg_psort files

2000-06-01 Thread Vladimir V. Zolotych
    Hello all, Please explain me the nature of pg_psort..M files? When they appears? Could I safely delete them from file system? One of these files is very big (more then 1GB) and wastes space. Such problem doesn't arrive before. If such files are temporary why them wasn't be deleted ?     T