[ADMIN] AAA 6.3 sparc version looking

2001-01-16 Thread Alberto Zocca
Hi, i'm looking for postgresql 6.3 version for debian (slink) on a sparc. Someone can help me to find it? Thanks Alberto

Re: [ADMIN] BAcking up a Postgres Database

2001-01-16 Thread Tim White
Yes, you do restore the archive logs from some backup medium. But I don't understand you point, the discussion relates to transaction logging, meaning that as dml statements are executed and committed they are logged, thus making it possible to re-apply them. To my knowledge Postgres does not do

[ADMIN] Help - Error in VACUUM

2001-01-16 Thread Francisco Eriko Barreto Brito
What is this? ERROR: index_formtuple: data takes 16468 bytes: too big When a try VACUUM ; Somebody can help? []'s Eriko

[ADMIN] date/time

2001-01-16 Thread snef
Hi, I have read the man's with Postgres. But I can't seem to get Postgres use European time notation (dd/mm/). Where can I adjust this? (in which file?) Snef

[ADMIN] How to back up a large object?

2001-01-16 Thread Jeff Xianfeng Liu
My table has about 5000 large objects. I just figured out that pg_dump cannot back up large objects. I am trying to move my database from a Solaris machine to a Linux (red hat 6.1). Unfortunately, all large objects are missing. I am new to Postgresql, and I found that large object operations in Po

[ADMIN] How to made available for a database an already installed language on another database ?

2001-01-16 Thread Richard Bayet
Here's the trick: I had to do a PostgreSQL install as a unix user. That's to say the postmaster process is ran under my login name, and all the database files belong to me. And so, my login name under this system was added (i presume when i launched initdb) in pg_user as a PostgreSQL superuser. I

[ADMIN] Re: How to made available for a database ... OUPS FORGOTTEN SOMETHING

2001-01-16 Thread Richard Bayet
I'm under PostgreSQL 7.0.2, and the server is a Sun Enterprise 450 under Solaris 2.5.1 Richard Bayet wrote : Too much to be read a second time

Re: [ADMIN] How to made available for a database an already installed language on another database ?

2001-01-16 Thread Tom Lane
Richard Bayet <[EMAIL PROTECTED]> writes: > And the problem is that they can't add any language support with > createlang. > Anytime they tried (for example '$>createlang plpgsql theirdb'), the > program seemed to "freeze" on authentification ... > They got a : > "$> createlang plpgsql theirdb > P