On Mon, Mar 3, 2008 at 5:47 AM, Guy Rouillier [EMAIL PROTECTED] wrote:
Greg Smith wrote:
Thanks to Joshua Drake and Command Prompt for providing hosting space
and even having an appropriate domain. To cut off one question I expect
to pop up, yes it would be nice to have this integrated
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the table
with a GIST index on that column. This fails horribly under 8.3; it
appears to be ok on the reload but as there is a trigger on updates any
update or insert fails immediately with a data mistype
Dear Sirs,
it is possible to connect to PostgreSQL server from a client with a dynamic
IP (or from an unknown IP)?
How I have to configure pg_hba.conf (and/or eventually my router, where the
server is located)?
I have no possibility to change the settings of clients (my customers)
Thank you.
yes, it is possible if you use a service like dyndns: http://www.dyndns.com/
to convert your dynamic ip. If you use this service you connect your
dynamic
ip to a hostname, which is dynamically updated by this service.
after that you can change your windows hosts file to add the hostname
you have
Em Monday 03 March 2008 07:01:17 dfx escreveu:
it is possible to connect to PostgreSQL server from a client with a dynamic
IP (or from an unknown IP)?
How I have to configure pg_hba.conf (and/or eventually my router, where the
server is located)?
You'll have to make PostgreSQL accept
am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes:
Dear Sirs,
it is possible to connect to PostgreSQL server from a client with a dynamic
IP (or from an unknown IP)?
Of course, yes.
How I have to configure pg_hba.conf (and/or eventually my router, where the
server is
I apologize for my confuse exposition.
My server has a static, well known IP.
The problem is that I don't know the IP of my customers (client side) and
then
I cannot insert those addresses in pg_hba.conf file.
The question il: Is there a method to avoid to insert the addesses of the
clients
in
On Mon, Mar 03, 2008 at 11:33:17AM +0100, A. Kretschmer wrote:
am Mon, dem 03.03.2008, um 11:01:17 +0100 mailte dfx folgendes:
Dear Sirs,
it is possible to connect to PostgreSQL server from a client with a dynamic
IP (or from an unknown IP)?
Of course, yes.
How I have to
am Mon, dem 03.03.2008, um 11:59:36 +0100 mailte Magnus Hagander folgendes:
How I have to configure pg_hba.conf (and/or eventually my router, where
the
server is located)?
Set the CIDR to 0.0.0.0/32.
That should be 0.0.0.0/0, I beleive.
//Magnus
Magnus, right. Thx.
Andreas
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only by username and password?
Yes, that's what people have been explaining: you insert a line
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only by username and password?
Maciej Sieczka wrote:
Isn't there a ready to use sort of addon for PgSQL which could intercept
the CREATE TABLE that eg. Base (or any other client) issues, appdend
GRANT to it and forward such a modified instruction to the server?
I looked a lot in list archives, PgFoundry, Google and can't
Richard Huxton wrote:
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the
table with a GIST index on that column. This fails horribly under
8.3; it appears to be ok on the reload but as there is a trigger on
updates any update or insert fails
Karl Denninger wrote:
Richard Huxton wrote:
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the
table with a GIST index on that column. This fails horribly under
8.3; it appears to be ok on the reload but as there is a trigger on
updates any update or
Michael Meskes wrote:
On Fri, Feb 29, 2008 at 11:27:25AM -0500, Steve Clark wrote:
Actually it appears to work in 8.2.5 but be broken in 8.2.6 and 8.3.0.
Are you really sure? It appears to me that there was no change between
8.2.5 and 8.2.6 that could affect ecpg's handling of arrays of
Michael Meskes wrote:
I just committed the attached small fix to CVS HEAD and the 8.3 branch.
This should fix your problem.
Michael
diff --exclude CVS -ru /home/postgres/pgsql-ecpg/preproc/type.c preproc/type.c
---
I can reproduce this as I have the dump from before conversion and can
load it on a different box and make it happen a second time.
Would you like it on the list or privately?
Karl Denninger ([EMAIL PROTECTED])
http://www.denninger.net
Richard Huxton wrote:
Karl Denninger wrote:
Richard
Karl Denninger wrote:
I can reproduce this as I have the dump from before conversion and can
load it on a different box and make it happen a second time.
Would you like it on the list or privately?
Privately, unless you can boil it down to a small schema fragment.
--
Richard Huxton
Thanks for the help! Stupid error,
Shad
On Feb 28, 7:04 am, [EMAIL PROTECTED] (Michael Fuhr) wrote:
On Wed, Feb 27, 2008 at 04:59:07PM -0800, shadrack wrote:
This may seem like a very simple question...it is...but I can't find
documentation on it to help. I've seen some posts about lat/long
Jorge Godoy wrote:
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only by
Collin wrote:
But make it hostssl instead of host, to require some
cryptography in the channel used, specially to authenticate the
connection.
Opening your access to everyone without crypto sounds like something
you don't want to do. Specially if users can change their own
passwords...
But make it hostssl instead of host, to require some cryptography
in the channel used, specially to authenticate the connection.
Opening your access to everyone without crypto sounds like something
you don't want to do. Specially if users can change their own
passwords...
My
Tom Lane wrote:
Scara Maccai [EMAIL PROTECTED] writes:
I got that there should be no difference... plus, I don't get any
errors,
You should have. The system enforces (or tries to) that a view can't be
part of an inheritance hierarchy, but you seem to have managed to find a
sequence of
Hello,
Jorge Godoy wrote:
Em Monday 03 March 2008 08:08:36 Raymond O'Donnell escreveu:
On 03/03/2008 11:01, dfx wrote:
The question il: Is there a method to avoid to insert the addesses of
the clients in the pg_hba.conf and to allow connections from internet
with security assured only
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
Scara Maccai [EMAIL PROTECTED] writes:
I got that there should be no difference... plus, I don't get any
errors,
You should have. The system enforces (or tries to) that a view can't be
part of an inheritance hierarchy, but you seem
Hello,
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to effect this support. Just a couple
of questions.
1. What Size, 10 or 100's, 1000's of elements?
2. Single or
Andrei Kovalevski [EMAIL PROTECTED] writes:
Does anybody ever measured performance slowdown for SSL connections?
It's pretty significant percentage-wise on a local-loopback connection,
but for a connection over the open Internet I doubt it'd be an issue.
Unless your data is completely not
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
Scara Maccai [EMAIL PROTECTED] writes:
I got that there should be no difference... plus, I don't get any
errors,
You should have. The system enforces (or tries to) that a view can't be
part of an inheritance
Dave Page wrote:
A postgresql.org wiki to replace techdocs is being worked on, per
recent discussion on -www, however it takes a little more effort than
a standalone one as we need to integrate it properly into the existing
infrastructure.
Dave, what is the intention of this wiki, as opposed
On Mon, Mar 03, 2008 at 10:42:50AM -0700, dmp wrote:
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to effect this support.
1. What Size, 10 or 100's, 1000's of
On Mon, 03 Mar 2008 10:42:50 -0700
dmp [EMAIL PROTECTED] wrote:
Hello,
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to effect this support. Just a couple
of questions.
On Mon, Mar 3, 2008 at 6:13 PM, Guy Rouillier [EMAIL PROTECTED] wrote:
Dave Page wrote:
A postgresql.org wiki to replace techdocs is being worked on, per
recent discussion on -www, however it takes a little more effort than
a standalone one as we need to integrate it properly into the
Thanks for telling me that Postgres doesn't support cross-database joins.
I know MS Sql Server does. And one of the companies I worked for used it, to
sometimes have a secure database with sensitive info behind a firewall join
queries with a less secure database.
Is this something worth
Hello list,
We are looking for someone with experience on the as/400 (running
os/400) platform, particularly in legacy environments. We are porting
an application to as many architectures as possible. We know very
little about as/400, but we have had some customers request support.
Does anybody
Swaminathan Saikumar wrote:
Thanks for telling me that Postgres doesn't support cross-database joins.
I know MS Sql Server does. And one of the companies I worked for used it, to
sometimes have a secure database with sensitive info behind a firewall join
queries with a less secure database.
On Mar 3, 2008, at 12:42 PM, Josh Trutwin wrote:
On Mon, 03 Mar 2008 10:42:50 -0700
dmp [EMAIL PROTECTED] wrote:
Hello,
The project MyJSQLView will provided basic support
for array types in PostgreSQL at the next release.
Information is desired from anyone that uses arrays
in PostgreSQL to
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
Where are you getting this information.
IMO the OP wanted to know how people *use* arrays, not how
one *can* use arrays.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
On Mon, 3 Mar 2008 20:48:55 +0100
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
Where are you getting this information.
IMO the OP wanted to know how people *use* arrays, not how
one *can* use arrays.
That was my thought, sort of a
On Mar 3, 2008, at 2:05 PM, Josh Trutwin wrote:
On Mon, 3 Mar 2008 20:48:55 +0100
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
Where are you getting this information.
IMO the OP wanted to know how people *use* arrays, not how
one
Hello - Curious if anyone has any experience with the new UUID type in
8.3? We are currently using sequences for all of our keys and ids.
However using a UUID instead of a sequence would make some parts of the
application easier. However we have a few concerns about performance
issues
1. What Size, 10 or 100's, 1000's of elements?
100 elements
2. Single or Multi-Dimensional?
2-dimensional
3. What data types?
integers
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I use arrays of integers, double or numeric, and text.
They are 1 or 2 dimensional.
They are usually limited to 100 elements in
one dimension and 10 in the other.
TJ O'Donnell
http://www.gnova.com
---(end of broadcast)---
TIP 1: if posting/reading
Ray
have you had a trawl through the archives?
Thanks for the response. Yes, I did. I tried a few things but did not find
anything that seemed to apply. Though it's possible I may have missed
something.
Dee [EMAIL PROTECTED] wrote: What are the permissions required to install
postgres
You should have. The system enforces (or tries to) that a view can't be
part of an inheritance hierarchy, but you seem to have managed to find a
sequence of operations that avoids those checks. Turning a table into a
view with a manual CREATE RULE operation has always been a kluge,
Scara Maccai [EMAIL PROTECTED] writes:
Is there a specific reason why views can't be part of an inheritance tree?
I mean: it's that we don't want it or it would be just difficult to
implement?
It would certainly require a lot of rethinking of assumptions, in the
planner and elsewhere. I have
I was slightly confused. I'm really trying to identify what type
of support the project should provide to array types. Just from
the input so far, it looks like more needs to be done. If 100's to
1000's of elements are in an array type, the application is going
to have some problems. Presently it
Em Monday 03 March 2008 13:17:03 você escreveu:
My understanding is no password is sent in the clear with md5 per:
http://www.postgresql.org/docs/8.3/interactive/auth-methods.html#AUTH-PASSW
ORD
But the MD5 hash is. This page states that the password can't be directly
sniffed, but one can
Jorge Godoy wrote:
Em Monday 03 March 2008 13:17:03 você escreveu:
My understanding is no password is sent in the clear with md5 per:
http://www.postgresql.org/docs/8.3/interactive/auth-methods.html#AUTH-PASSW
ORD
But the MD5 hash is. This page states that the password can't be directly
Tom Lane wrote:
hernan gonzalez [EMAIL PROTECTED] writes:
test=# create view vchartest as
select encode(convert_to(c,'LATIN9'),'escape') as c1 from chartest;
Hmm. This isn't a very sensible combination that you've written here,
but I see the point: encode(..., 'escape') is broken in
Scott Marlowe wrote:
On Feb 19, 2008 11:39 PM, Tom Lane [EMAIL PROTECTED] wrote:
and since postgresql functions cannot return cursor to the
calling applications,
Likewise a false statement.
Yeah, I remembered there being a section on returning cursors. I went
to the docs page and
Karl Denninger [EMAIL PROTECTED] writes:
Anyone know where the magic incantation is to find the crypto libraries?
If the RPM layout is the same as Fedora (which it surely oughta be)
openssl is what provides libcrypto.so.
regards, tom lane
---(end
Harald,
Thanks for the response.
1.) you should prefer windows 2003 for your first PostgreSQL install
on windows. Installation on Windows 2000 is a lot more challenging.
BTW: main stream support for 2000 by Microsoft ended on 2005-06-30, so
unless you have contracts with MS for extended
Hi,
On Tue, 2008-03-04 at 00:34 -0500, Tom Lane wrote:
Karl Denninger [EMAIL PROTECTED] writes:
Anyone know where the magic incantation is to find the crypto
libraries?
If the RPM layout is the same as Fedora (which it surely oughta be)
openssl is what provides libcrypto.so.
I think you
53 matches
Mail list logo