[ADMIN] Recovery/Rollback question

2007-02-26 Thread Antje . Stejskal
Hi, I am new to the list and want to say hello first. We are migrating to Postgres and therefore my question might be simple for you. We run several application databases under one db server. Now we are looking for a mechanism to rollback unwanted user command without impact for other databases.

Re: [ADMIN] can i use to_ascii function ?

2007-02-26 Thread Michael Fuhr
[Once again, please copy the mailing list on replies so others can participate in and learn from the discussion. Also, pgsql-general might be a more appropriate list than pgsql-admin.] On Mon, Feb 26, 2007 at 10:53:48AM +0100, j n wrote: 1. At first i tried use to_ascii ... convert it works

[ADMIN] host name?

2007-02-26 Thread Igor Neyman
Is there a function (or catalog view) that I can call in psql and that will tell me host name of the machine on which Postgres database is running? Igor

Re: [ADMIN] host name?

2007-02-26 Thread Andy Shellam (Mailing Lists)
Igor Neyman wrote: Is there a function (or catalog view) that I can call in psql and that will tell me host name of the machine on which Postgres database is running? Igor Surely you need to know this to connect to it in the first place?

Re: [ADMIN] host name?

2007-02-26 Thread Igor Neyman
And one more question. Is there a way (function/view) to find machine name on which user program (connected to Postgres) runs? Igor From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman Sent: Monday, February 26, 2007 10:29 AM To:

[ADMIN] kerberized odbc driver

2007-02-26 Thread David Bear
I was hoping there was a kerberized odbc driver for postgresql that works on windows. I know this is a longshot. Anyone? -- David Bear phone: 602-496-0424 fax:602-496-0955 College of Public Programs/ASU University Center Rm 622 411 N Central Phoenix, AZ 85007-0685 Beware the IP portfolio,

Re: [ADMIN] host name?

2007-02-26 Thread Igor Neyman
You are right, wrong question. What I really want to know is formulated in my next message. Which is: based on program (connected to PG) name find the machine name it runs on. For those familiar with Oracle, it's program, machine columns in v$session view. Igor

[ADMIN] UNSUBSCRIBE

2007-02-26 Thread Franco
UNSUBSCRIBE - Preguntá. Respondé. Descubrí. Todo lo que querías saber, y lo que ni imaginabas, está en Yahoo! Respuestas (Beta). Probalo ya!

Re: [ADMIN] kerberized odbc driver

2007-02-26 Thread Joshua D. Drake
David Bear wrote: I was hoping there was a kerberized odbc driver for postgresql that works on windows. I know this is a longshot. Anyone? You are shooting over a mountain with a plastic arrow. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support:

[ADMIN] Disconnecting non active (IDLE ) users

2007-02-26 Thread Goran Rakic
I have installed POSTGRESQL 8.2 on W2K3 32bit , 100 users connecting from desktop applications and 200 users connecting thru web service from handheld computers I have problem with second groups of users. Often they do not disconnect from POSTGRE Server and with time passing thru I have lot

Re: [ADMIN] kerberized odbc driver

2007-02-26 Thread Ludek Finstrle
Mon, Feb 26, 2007 at 09:06:04AM -0800, Joshua D. Drake napsal(a): David Bear wrote: I was hoping there was a kerberized odbc driver for postgresql that works on windows. I know this is a longshot. Anyone? I think it works with psqlodbc. Isn't it? BTW at least 08.01.X series works. You have

[ADMIN] U NSUBSCRIBE

2007-02-26 Thread Nabil Sawaya
---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [ADMIN] kerberized odbc driver

2007-02-26 Thread Tom Lane
David Bear [EMAIL PROTECTED] writes: I was hoping there was a kerberized odbc driver for postgresql that works on windows. I know this is a longshot. I'm afraid so ... but Those Who Would Know are much more likely to be hanging out in pgsql-odbc than on this list.

Re: [ADMIN] host name?

2007-02-26 Thread Ray Stell
not sure how to resolve the name, but maybe this is close enough: select usename, client_addr from pg_catalog.pg_stat_activity; On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman wrote: You are right, wrong question. What I really want to know is formulated in my next message. Which is:

Re: [ADMIN] host name?

2007-02-26 Thread Igor Neyman
Right, I looked at pg_stat_activity, but besides having ip address (instead of machine name), it doesn't have clent program name connected to PG. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Stell Sent: Monday, February 26, 2007 12:53 PM To: Igor

Re: [ADMIN] host name?

2007-02-26 Thread Igor Neyman
Right, I looked at pg_stat_activity. But besides having ip address (instead of machine name), it doesn't have clent program name connected to PG. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Stell Sent: Monday, February 26, 2007 12:53 PM To:

Re: [ADMIN] host name?

2007-02-26 Thread Peter Eisentraut
Igor Neyman wrote: But besides having ip address (instead of machine name), it doesn't have clent program name connected to PG. That information is not available to the server. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of

Re: [ADMIN] Recovery/Rollback question

2007-02-26 Thread Jason Minion
This is currently unsupported in mainstream PostgreSQL, as the WAL only works on the cluster basis. The only options you currently have for performing this is to use the last full backup and copies of WAL files to restore the cluster on a second server to your specific point in time, and restore

Re: [ADMIN] Recovery/Rollback question

2007-02-26 Thread Scott Marlowe
On Mon, 2007-02-26 at 07:57, [EMAIL PROTECTED] wrote: Hi, I am new to the list and want to say hello first. We are migrating to Postgres and therefore my question might be simple for you. We run several application databases under one db server. Now we are looking for a mechanism to