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.
[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
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
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?
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:
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,
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
UNSUBSCRIBE
-
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
Probalo ya!
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:
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
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
---(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
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.
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:
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
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 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
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
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
19 matches
Mail list logo