[ADMIN] list triggers

Hello, I am a bit new to postgresql so please excuse me for my lame questions. 1) How can I see all triggers on specific table or list of triggers in the database? 2) How can i monitor connections to database some thing equal to "show processlist" in mysql.     I would like to see who is connecte

[ADMIN] data type comparable to Oracle RAW LONG

What PostgreSQL data type is equivalent to Oracle's RAW LONG? Warren Bakker __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ ---(end of broadcast)--- TIP 6:

[ADMIN] Grant all to Public & adding users

We have existing database where several tables have GRANT ALL TO PUBLIC. However, when new users are added, they seem to get privilege problem until another GRANT ALL TO PUBLIC is issued. If this is truly the case (and we're not crazy) then each time a new user is added, new GRANTs will have to b

Re: [ADMIN] Grant all to Public & adding users

"Marc Mitchell" <[EMAIL PROTECTED]> writes: > We have existing database where several tables have GRANT ALL TO PUBLIC. > However, when new users are added, they seem to get privilege problem until > another GRANT ALL TO PUBLIC is issued. If this is truly the case (and > we're not crazy) then each

Re: [ADMIN] Grant all to Public & adding users

Marc Mitchell writes: > We have existing database where several tables have GRANT ALL TO PUBLIC. > However, when new users are added, they seem to get privilege problem until > another GRANT ALL TO PUBLIC is issued. I cannot reproduce this in 7.0.2 or in current, so either you are using an even

[ADMIN] Installing Postgres v7.1.3 with support for Greek Characters

Greetings, Is there support for Greek characters using ISO-8859-7 in the latest production version of Postgres, v7.1.3? I can see that it is possible to use ./configure --enable-multibyte[=encoding_system] --enable-locale but the list of available encodings does not seem to include ISO-8859-

[ADMIN] replication

Hello I want to add replication capabilities to my postgresql installation. Can anyone recommend a good way (open source or otherwise) to do so? Basically, I have a web tracking application that must quickly and reliably store massive amounts of tracking data. Later, I run complex queries to ana

Re: [ADMIN] replication

Peter T. Brown writes: > > I want to add replication capabilities to my postgresql installation. Can > anyone recommend a good way (open source or otherwise) to do so? > [snip] Check the contrib/rserv/ directory in the PostgreSQL source. Also check http://techdocs.postgresql.org/oresources.php#

Re: [ADMIN] replication

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday, January 11, 2002, at 09:27 AM, Peter T. Brown wrote: > Hello > > I want to add replication capabilities to my postgresql installation. > Can > anyone recommend a good way (open source or otherwise) to do so? I read this the other day,

[ADMIN] Fwd: db seems to be corrupt but continues to work. It won't let me do a pg_dump

Hello, I've a db named "4unrealers". It has been running smoothly until yesterday. While I was revising the backup process[1] I noticed this message: dharana@triton:~$ pg_dump -c 4unrealers getTableAttrs(): SELECT (for DEFAULT) for attr fmid returned 0 tuples. Expected 1. Then I tried the follo

[ADMIN] Is this list working?

I'm reading the list through Google groups, but I haven't seen much activity on admin, hackers, sql, etc. over the last few weeks. Are there just not any posts or is something screwy with Google groups newsserver? I was hoping to see the status of 7.2. -Tony [EMAIL PROTECTED] -