pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: postgresql
68+ messages / 50 participants
[nested] [flat]
* Re: postgresql
@ 1999-05-16 09:51 Geoff Keating <geoffk@ozemail.com.au>
0 siblings, 0 replies; 68+ messages in thread
From: Geoff Keating @ 1999-05-16 09:51 UTC (permalink / raw)
To: Franz.Sirl-kernel@lauterbach.com; +Cc: howarth@bromo.med.uc.edu; pgsql-general
> From: Franz Sirl <Franz.Sirl-kernel@lauterbach.com>
> Date: Fri, 14 May 1999 18:54:59 +0200
>
> Hi,
>
> it seems that this problem is a type casting/promotion bug in the source. The
> routine _bt_checkkeys() in backend/access/nbtree/nbtutils.c calls int2eq() in
> backend/utils/adt/int.c via a function pointer *fmgr_faddr(&key[0].sk_func). As
> the type information for int2eq is lost via the function pointer, the compiler
> passes 2 ints, but int2eq expects 2 (preformatted in a 32bit reg) int16's.
> This particular bug goes away, if I for example change int2eq to:
>
> bool
> int2eq(int32 arg1, int32 arg2)
> {
> return (int16)arg1 == (int16)arg2;
> }
>
> This moves away the type casting/promotion "work" from caller to the callee and
> is probably the right thing to do for functions used via function pointers.
>
> As there are quite a lot changes to do and check, it would be best to forward
> this to the postgresql maintainers.
It may help to prototype the function to match the way it is called:
int int2eq();
bool int2eq(int16 a, int16 b)
{
return a == b;
}
and then gcc will say something like:
z.c:6: conflicting types for `int2eq'
z.c:6: An argument type that has a default promotion
z.c:6: can't match an empty parameter name list declaration.
z.c:3: previous declaration of `int2eq'
which is correct. Of course, to actually make the thing compile you
then need to change the 'int16' to 'int'; but the prototype warns the
compiler of what's going on, so it may help avoid other problems with
the trickiness that PostgreSQL uses.
Otherwise, it's also acceptable to insert an appropriate cast whenever
such functions are used, so you'd write (*(int
*(int16,int16))fmgr_addr(xxx))(xxx) for some 'xxx'. This has the
advantage that you won't accidentally pass a 'long' when the routine
expects an 'int'. Of course, you'd use a typedef not just put
the type in directly.
I've added the postgresql main mailing list so that they know why
things don't work on powerpc. I expect they will have similar
problems on alpha and/or sparc.
--
Geoffrey Keating <geoffk@ozemail.com.au>
^ permalink raw reply [nested|flat] 68+ messages in thread
* postgresql
@ 1999-08-11 19:01 jeremy@xxedgexx.com
0 siblings, 0 replies; 68+ messages in thread
From: jeremy@xxedgexx.com @ 1999-08-11 19:01 UTC (permalink / raw)
To: gpsql-general <pgsql-general@hub.org>
I like postgresql.
Thanks
-jeremy
http://www.xxedgexx.com | jeremy@xxedgexx.com
---------------------------------------------
Y2K. We're all gonna die.
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 1999-10-07 13:10 Allan Huffman <huffmana@ppc.pims.org>
0 siblings, 0 replies; 68+ messages in thread
From: Allan Huffman @ 1999-10-07 13:10 UTC (permalink / raw)
To: pgsql-general
Dear Sirs,
I am using Java with JDBC (PC) to run an application using PostgreSQL
6.2.1 (Sparc). Everything is running fine except for a string problem.
The Postmaster says:
"ERROR: MultiByte strings (MB) must be enabled to use this function"
The DOS prompt (where the Visual Cafe development environment runs an
Applet) tells me:
"The maximum width size for column 3 is: 13"
And this is for a varchar(50) field. When I enter a string into the
column from my Java text field I get the diagnostic:
"Invalid value for the column: product_name"
I figure that all I have to do is enable MB but I can't find it. If you
have not encountered this problem before, do you know of a user group
where I can post a question.
Sincerely,
Allan in Belgium
Allan@ppc.pims.org
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 1999-11-02 15:47 HK Woo <hung_kai_woo@hotmail.com>
0 siblings, 1 reply; 68+ messages in thread
From: HK Woo @ 1999-11-02 15:47 UTC (permalink / raw)
To: pgsql-questions@postgresql.org
Hi,
I am very new to Linux. I have a question about PostgreSQL. If I start up a
PostgreSQL on Linux machine, can I use it as backend database engine for
WIN9X application. If I can, how to do it?.
Thank you!
HK
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 1999-11-02 18:56 zris <zris@somewhere.com>
parent: HK Woo <hung_kai_woo@hotmail.com>
0 siblings, 1 reply; 68+ messages in thread
From: zris@somewhere.com @ 1999-11-02 18:56 UTC (permalink / raw)
To: pgsql-questions@postgresql.org
Postgres does have a ODBC install so I think you will be able toc
onnect to the database like most other databases.
zris
On Tue, 2 Nov 1999 23:47:35 +0800, "HK Woo" <hung_kai_woo@hotmail.com>
wrote:
>Hi,
>
>I am very new to Linux. I have a question about PostgreSQL. If I start up a
>PostgreSQL on Linux machine, can I use it as backend database engine for
>WIN9X application. If I can, how to do it?.
>
>Thank you!
>
>HK
>
>
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 1999-11-26 15:49 Horaci Cuevas <hcuevas@perti.com>
0 siblings, 0 replies; 68+ messages in thread
From: Horaci Cuevas @ 1999-11-26 15:49 UTC (permalink / raw)
To: pgman@candle.pha.pa.us
Hi!
I'm using PostgreSQL for a search-web based database, and i saw a missing
function mostly found in DB2 and others, where, you can get results from
a query having a WHERE condition to exist or not in another SQL sentence .
In DB2 is:
SELECT field1, field2 FROM tab1 WHERE field1 IN ( select field3 from tab2 )
or
SELECT field1, field2 FROM tab1 where field1 NOT IN ( select field3 from tab2 )
PostgreSQL already has that, but only allows to return 1 result, ex:
SELECT field1, field2 FROM tab1 where field1 =
( select field 3 from tab2 where id=1 )
Would be great if that where added to the TODO as a future Feature.
Thanks in Advance.
Horaci Cuevas.
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 1999-11-26 23:12 Matthew Leo <matt@acrcorp.removethis.com>
parent: zris <zris@somewhere.com>
0 siblings, 0 replies; 68+ messages in thread
From: Matthew Leo @ 1999-11-26 23:12 UTC (permalink / raw)
To: pgsql-questions@postgresql.org
I'm figuring this stuff out for myself rightnow. Here's what I've got
so far.
Visit this location to obtain the win32 ODBC driver:
http://www.insightdist.com/psqlodbc.
If you've created your database, make sure you edit the file pg_hba.conf
in your default database directory to include a line allowing
connections from your windows machines over IP (assuming you have a
network 192.168.0.*), for example:
host all 192.168.0.0 255.255.255.0 trust
to give completely unfettered access to everything, ignoring passwords.
Obviously, this is probably more permissive than you really want to be!
It's a start for config testing.
Assuming this works, be a little less trusing, change the line to:
host all 192.168.0.0 255.255.255.0 password pg_pwd
This requires a password and looks into the file pg_pwd in your database
directory for the password. You can run the command "pg_passwd pg_pwd"
to set passwords in this file.
That's as far as I've got. Other methods include kerberos, crypt (no
plaintext password transmitted -- a good idea), and ident (the ident
protocol -- don't know about this one). If anyone has any knowledge
about integrating with NT domains that would be great.
-Matt
^ permalink raw reply [nested|flat] 68+ messages in thread
* Postgresql
@ 2000-06-07 14:39 Mihai Gheorghiu <tanhq@bigplanet.com>
0 siblings, 3 replies; 68+ messages in thread
From: Mihai Gheorghiu @ 2000-06-07 14:39 UTC (permalink / raw)
To: pgsql-general
The following is a quote from a consultant's opinion on my intention to
migrate to Postgresql.
Quote:
The use of Postgres is cautioned for mission critical data by the developers
of Postgres themselves.
Unquote.
Please comment.
Best regards,
Mihai
PS See also pgsql-interfaces for opinion on Postgres ODBC interface for
Windows :-)
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2000-06-07 19:57 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Mihai Gheorghiu <tanhq@bigplanet.com>
2 siblings, 1 reply; 68+ messages in thread
From: Bruce Momjian @ 2000-06-07 19:57 UTC (permalink / raw)
To: Mihai Gheorghiu <tanhq@bigplanet.com>; +Cc: pgsql-general
[ Charset ISO-8859-1 unsupported, converting... ]
> The following is a quote from a consultant's opinion on my intention to
> migrate to Postgresql.
> Quote:
> The use of Postgres is cautioned for mission critical data by the developers
> of Postgres themselves.
> Unquote.
> Please comment.
>
I have been around for 4 years, and have never heard that said by anyone
closely related to the project.
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2000-06-07 20:07 Vince Vielhaber <vev@michvhf.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 68+ messages in thread
From: Vince Vielhaber @ 2000-06-07 20:07 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Mihai Gheorghiu <tanhq@bigplanet.com>; pgsql-general
On Wed, 7 Jun 2000, Bruce Momjian wrote:
> [ Charset ISO-8859-1 unsupported, converting... ]
> > The following is a quote from a consultant's opinion on my intention to
> > migrate to Postgresql.
> > Quote:
> > The use of Postgres is cautioned for mission critical data by the developers
> > of Postgres themselves.
> > Unquote.
> > Please comment.
> >
>
> I have been around for 4 years, and have never heard that said by anyone
> closely related to the project.
I recall seeing that quote somewhere, but it wasn't on our site nor was
it said by anyone associated with Postgres. I'm thinking it was in either
an online magazine or something like that. It was many months ago, tho.
Almost a year, perhaps longer.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2000-06-07 21:29 Jim Jennis <jhjennis@shentel.net>
parent: Mihai Gheorghiu <tanhq@bigplanet.com>
2 siblings, 1 reply; 68+ messages in thread
From: Jim Jennis @ 2000-06-07 21:29 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-general
I agree Bruce!
Sounds like a quote from an Oracle or SQL Server sales rep/consultant to me!
Postgres is fantastic!
Thanks to the team and keep up the great work!
Regards,
Jim
At 15:57 6/7/2000 -0400, you wrote:
>[ Charset ISO-8859-1 unsupported, converting... ]
>> The following is a quote from a consultant's opinion on my intention to
>> migrate to Postgresql.
>> Quote:
>> The use of Postgres is cautioned for mission critical data by the
developers
>> of Postgres themselves.
>> Unquote.
>> Please comment.
>>
>
>I have been around for 4 years, and have never heard that said by anyone
>closely related to the project.
>
>--
> Bruce Momjian | http://www.op.net/~candle
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
>
,-,-. ,-,-. ,-,-. ,-,-. ,-
/ / \ \ / / \ \ / / \ \ / / \ \ / /
\ \ / / \ \ / / \ \ / / \ \ / /
`-'-' `-'-' `-'-' `-'-'
--------------------------------------------------------
FSC - Building Better Information Technology Solutions-
From the Production Floor to the Customer's Door.
--------------------------------------------------------
Jim Jennis, Technical Director, Commercial Systems
Fuentez Systems Concepts, Inc.
1 Discovery Place, Suite 2
Martinsburg, WV. 25401 USA.
Phone: +001 (304) 263-0163 ext 235
FAX: +001 (304) 263-0702
Email: jjennis@fuentez.com
jhjennis@shentel.net
Web: http://www.discovery.fuentez.com/
---------------------------------------------------
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2000-06-08 02:56 Tom Dryden <tdryden@earthlink.net>
parent: Jim Jennis <jhjennis@shentel.net>
0 siblings, 0 replies; 68+ messages in thread
From: Tom Dryden @ 2000-06-08 02:56 UTC (permalink / raw)
To: Jim Jennis <jhjennis@shentel.net>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-general
excuse me but I have been attempting to drop my subscription ti this list
How does one get off of this list?
Jim Jennis wrote:
> I agree Bruce!
>
> Sounds like a quote from an Oracle or SQL Server sales rep/consultant to me!
>
> Postgres is fantastic!
>
> Thanks to the team and keep up the great work!
>
> Regards,
>
> Jim
>
> At 15:57 6/7/2000 -0400, you wrote:
> >[ Charset ISO-8859-1 unsupported, converting... ]
> >> The following is a quote from a consultant's opinion on my intention to
> >> migrate to Postgresql.
> >> Quote:
> >> The use of Postgres is cautioned for mission critical data by the
> developers
> >> of Postgres themselves.
> >> Unquote.
> >> Please comment.
> >>
> >
> >I have been around for 4 years, and have never heard that said by anyone
> >closely related to the project.
> >
> >--
> > Bruce Momjian | http://www.op.net/~candle
> > pgman@candle.pha.pa.us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> >
> >
> ,-,-. ,-,-. ,-,-. ,-,-. ,-
> / / \ \ / / \ \ / / \ \ / / \ \ / /
> \ \ / / \ \ / / \ \ / / \ \ / /
> `-'-' `-'-' `-'-' `-'-'
> --------------------------------------------------------
> FSC - Building Better Information Technology Solutions-
> From the Production Floor to the Customer's Door.
> --------------------------------------------------------
>
> Jim Jennis, Technical Director, Commercial Systems
> Fuentez Systems Concepts, Inc.
> 1 Discovery Place, Suite 2
> Martinsburg, WV. 25401 USA.
>
> Phone: +001 (304) 263-0163 ext 235
> FAX: +001 (304) 263-0702
>
> Email: jjennis@fuentez.com
> jhjennis@shentel.net
> Web: http://www.discovery.fuentez.com/
> ---------------------------------------------------
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2000-06-08 12:49 The Hermit Hacker <scrappy@hub.org>
parent: Mihai Gheorghiu <tanhq@bigplanet.com>
2 siblings, 0 replies; 68+ messages in thread
From: The Hermit Hacker @ 2000-06-08 12:49 UTC (permalink / raw)
To: Mihai Gheorghiu <tanhq@bigplanet.com>; +Cc: pgsql-general
On Wed, 7 Jun 2000, Mihai Gheorghiu wrote:
> The following is a quote from a consultant's opinion on my intention to
> migrate to Postgresql.
> Quote:
> The use of Postgres is cautioned for mission critical data by the developers
> of Postgres themselves.
> Unquote.
> Please comment.
Maybe way back in the pre-v6.0 days ... 3 years ago ...
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgresql
@ 2000-09-29 17:10 Tim Kientzle <kientzle@acm.org>
0 siblings, 0 replies; 68+ messages in thread
From: Tim Kientzle @ 2000-09-29 17:10 UTC (permalink / raw)
To: pgsql-general
The mailing address in my address book (which is what I generally use):
pgsql-general@postgresql.org
The daily digests I get have the following email address at the top:
pgsql-general@hub.org
Both seem to work for me.
- Tim
Richard Brown wrote:
>
> Hi there,
>
> Sorry to bother you, I just picked you at random. I'm completely failing to
> be able to send emails to the postgres list and was just wondering what
> address you send your messages to, mayber I'm getting it wrong. I certainly
> don't see them on the list and I don't get any errors back.
>
> Thanks for your time,
> Richard.
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 2003-03-26 18:06 Camarao, Wagner (v) <Wagner.Camarao@bowneglobal.com.br>
0 siblings, 0 replies; 68+ messages in thread
From: Camarao, Wagner (v) @ 2003-03-26 18:06 UTC (permalink / raw)
To: 'info@pgsql.com' <info@pgsql.com>
Hello there, I hope I can count on your help.
Is it possible to referes to a table from an external database in
the same server while executing a command?
Suppose I am connected to my databaseA and I want to get some data
from databaseB (on the same server). Should I do something like:
insert into tableA (select * from databaseB.tableB);
like [dbo]. in MS SQL Server??
Thank's,
___________________________________
Wagner Camarão, Developer
Bowne Global Solutions
Phone +55 21 2515-7830
Mobile +55 21 8856-8568
wagner.camarao@bowneglobal.com.br
www.bowneglobal.com.br
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 2003-06-26 22:09 Ulisses Ponticelli Giorgi <ulisses@compus.com.br>
0 siblings, 2 replies; 68+ messages in thread
From: Ulisses Ponticelli Giorgi @ 2003-06-26 22:09 UTC (permalink / raw)
To: pgsql-general
Hi,
I´m SQL Server 2000 user and want to migrate to PostgreSQL,
mainly because is the most suitable database to my needs (it is very
robust) and because the price of SQL Server is scaring all my clients.
But I have a few problems with PostgreSQL that I'm stuck.
1) In my SQL Server database I have about 1,000 Stored
Procedures. In some cases, one SP calls another SP that calls another,
and so on. To do that, I use the EXEC command. I've read that PostgreSQL
only supports functions. Is there any kind of trick that I can use in
PostgreSQL to make easier the conversion of all my SPs? How could I do
this? I just can't get all my SPs and rewrite the code.
2) I use commands like CONVERT and CASE..WHEN..END in my
queries. This is another issue that I simply don't know what to do. Is
there any kind of library or product (if it exists, I but it) that can
solve this problem?
Please, sorry my lack of knowledge in PostgreSQL. I'm a beginner
in this database, but I believe that is the answer to my problems, manly
because the SQL Server is unbearable to maintain.
Best Regards,
Ulisses Ponticelli Giorgi
MSC Computer Science
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-07-01 23:36 DeJuan Jackson <djackson@speedfc.com>
parent: Ulisses Ponticelli Giorgi <ulisses@compus.com.br>
1 sibling, 0 replies; 68+ messages in thread
From: DeJuan Jackson @ 2003-07-01 23:36 UTC (permalink / raw)
To: Ulisses Ponticelli Giorgi <ulisses@compus.com.br>; +Cc: pgsql-general
Welcome to the light.
Ulisses Ponticelli Giorgi wrote:
> Hi,
>
> I´m SQL Server 2000 user and want to migrate to PostgreSQL,
>mainly because is the most suitable database to my needs (it is very
>robust) and because the price of SQL Server is scaring all my clients.
>
> But I have a few problems with PostgreSQL that I'm stuck.
>
> 1) In my SQL Server database I have about 1,000 Stored
>Procedures. In some cases, one SP calls another SP that calls another,
>and so on. To do that, I use the EXEC command. I've read that PostgreSQL
>only supports functions. Is there any kind of trick that I can use in
>PostgreSQL to make easier the conversion of all my SPs? How could I do
>this? I just can't get all my SPs and rewrite the code.
>
As far as I know there is no SQL Server compatibility for PostgreSQL.
So (not really related to the preceding statement), you will have to
rewrite your Stored Procedures. And don't let the terms confuse you
most (if not all) Store Procs can be written using PostgreSQL functions
(a procedure is generally a function that returns nothing in programming
terms). This will be the most painful point of the migration, but you
would/will have the same problem with migration to any other database.
> 2) I use commands like CONVERT and CASE..WHEN..END in my
>queries. This is another issue that I simply don't know what to do. Is
>there any kind of library or product (if it exists, I but it) that can
>solve this problem?
>
(In that I haven't read the SQL Server 2000 doc's take the following
statements with a grain of salt.)
for an appropriate reference start here:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functions.html
CASE is SQL standard => read will work in PostgreSQL as in SQL Server
2000 with little to no changes (Section 6.12.1 in the docs).
CONVERT is a type conversion function and would need to be rewritten
using the equivalent functions in PostgreSQL(Section 6.7 in the docs).
>
> Please, sorry my lack of knowledge in PostgreSQL. I'm a beginner
>in this database, but I believe that is the answer to my problems, manly
>because the SQL Server is unbearable to maintain.
>
We all have to start somewhere, best to start with the Fine Manual.
>
>
>Best Regards,
>
>Ulisses Ponticelli Giorgi
> MSC Computer Science
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-07-02 06:01 Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
parent: Ulisses Ponticelli Giorgi <ulisses@compus.com.br>
1 sibling, 0 replies; 68+ messages in thread
From: Shridhar Daithankar @ 2003-07-02 06:01 UTC (permalink / raw)
To: pgsql-general
On 26 Jun 2003 at 19:09, Ulisses Ponticelli Giorgi wrote:
> 1) In my SQL Server database I have about 1,000 Stored
> Procedures. In some cases, one SP calls another SP that calls another,
> and so on. To do that, I use the EXEC command. I've read that PostgreSQL
> only supports functions. Is there any kind of trick that I can use in
> PostgreSQL to make easier the conversion of all my SPs? How could I do
> this? I just can't get all my SPs and rewrite the code.
I was under impression functions are stored procedures. I mean OK, if you write
them in PL/PgSQL. Shouldn't be a problem barring syntax differences..
HTH
Bye
Shridhar
--
Fun experiments: Get a can of shaving cream, throw it in a freezer for about a
week. Then take it out, peel the metal off and put it where you want...
bedroom, car, etc. As it thaws, it expands an unbelievable amount.
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 2003-08-10 15:58 Eugeny Balakhonov <ccs@dubki.ru>
0 siblings, 1 reply; 68+ messages in thread
From: Eugeny Balakhonov @ 2003-08-10 15:58 UTC (permalink / raw)
To: pgsql-general
Hello, all!
I have a good question for PostgreSQL FAQ.
How to use string functions (like UPPER()/LOWER()) for non-latin strings?
Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)?
How to make case insensetive search by text field which contains non-latin characters?
Thanks for your answers!
Best regards
Eugeny
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-08-11 03:35 Alexander Litvinov <lan@ac-sw.com>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 68+ messages in thread
From: Alexander Litvinov @ 2003-08-11 03:35 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; Eugeny Balakhonov <ccs@dubki.ru>; +Cc: pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I confirm this behavour: cyrilic words are not changed by lower()/upper()
functions, nor catched by ilike.
I am using :
=> SELECT version();
version
- ---------------------------------------------------------------
PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
(1 row)
Nothing special was done during database creation (no encoding selected).
> Not sure. I thought it would work.
> > How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> > Why UPPER() function doesn't work with my UNICODE PostgreSQL database
> > which contains non-latin characters (like cyrillic)? How to make case
> > insensetive search by text field which contains non-latin characters?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iD8DBQE/Nw7wV+WKOINIfOYRAuhmAJwMEkdgqXkt6ZhgJsFZfQH2mELRwgCfeDeV
L9TbSItEb0tAC7cI0cKwg6A=
=veHN
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-08-11 04:01 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Eugeny Balakhonov <ccs@dubki.ru>
0 siblings, 2 replies; 68+ messages in thread
From: Bruce Momjian @ 2003-08-11 04:01 UTC (permalink / raw)
To: Eugeny Balakhonov <ccs@dubki.ru>; +Cc: pgsql-general
Not sure. I thought it would work.
---------------------------------------------------------------------------
Eugeny Balakhonov wrote:
> Hello, all!
>
> I have a good question for PostgreSQL FAQ.
>
> How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)?
> How to make case insensetive search by text field which contains non-latin characters?
>
> Thanks for your answers!
>
> Best regards
> Eugeny
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-08-11 08:33 Oleg Bartunov <oleg@sai.msu.su>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 68+ messages in thread
From: Oleg Bartunov @ 2003-08-11 08:33 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Eugeny Balakhonov <ccs@dubki.ru>; pgsql-general
On Mon, 11 Aug 2003, Bruce Momjian wrote:
>
> Not sure. I thought it would work.
>
No, it doesn't works. Several people already complained about bad
unicode support. I recall Tatsuo comment some piece of code.
I have a little page http://www.sai.msu.su/~megera/postgres/utf8.html
about my experience with UTF8 and cyrillic.
> ---------------------------------------------------------------------------
>
> Eugeny Balakhonov wrote:
> > Hello, all!
> >
> > I have a good question for PostgreSQL FAQ.
> >
> > How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> > Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)?
> > How to make case insensetive search by text field which contains non-latin characters?
> >
> > Thanks for your answers!
> >
> > Best regards
> > Eugeny
>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-08-11 21:44 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Oleg Bartunov <oleg@sai.msu.su>
0 siblings, 1 reply; 68+ messages in thread
From: Bruce Momjian @ 2003-08-11 21:44 UTC (permalink / raw)
To: Oleg Bartunov <oleg@sai.msu.su>; +Cc: Eugeny Balakhonov <ccs@dubki.ru>; pgsql-general
Well, I have no mention of this problem in the TODO list, so I would
like to get a good description of why it isn't working.
Looking at the code, I see upper() is defined in oracle_compat.c (you
would think it would be more standard), and it calls toupper(), so it
probably works on single-bytes encodings, but not multi-byte ones. Is
this correct? is there a way to do multi-byte toupper? Perhaps
converting to wide characters and calling towupper()?
---------------------------------------------------------------------------
Oleg Bartunov wrote:
> On Mon, 11 Aug 2003, Bruce Momjian wrote:
>
> >
> > Not sure. I thought it would work.
> >
>
> No, it doesn't works. Several people already complained about bad
> unicode support. I recall Tatsuo comment some piece of code.
> I have a little page http://www.sai.msu.su/~megera/postgres/utf8.html
> about my experience with UTF8 and cyrillic.
>
>
>
> > ---------------------------------------------------------------------------
> >
> > Eugeny Balakhonov wrote:
> > > Hello, all!
> > >
> > > I have a good question for PostgreSQL FAQ.
> > >
> > > How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> > > Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)?
> > > How to make case insensetive search by text field which contains non-latin characters?
> > >
> > > Thanks for your answers!
> > >
> > > Best regards
> > > Eugeny
> >
> >
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-08-11 22:28 Dennis Gearon <gearond@cvc.net>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 68+ messages in thread
From: Dennis Gearon @ 2003-08-11 22:28 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Oleg Bartunov <oleg@sai.msu.su>; Eugeny Balakhonov <ccs@dubki.ru>; pgsql-general
I think if Postgres were to be completely UTF8 compatible, and as the default configuration, we'd do a lot better against 'the others', and take more of Oracle's market.
Bruce Momjian wrote:
> Well, I have no mention of this problem in the TODO list, so I would
> like to get a good description of why it isn't working.
>
> Looking at the code, I see upper() is defined in oracle_compat.c (you
> would think it would be more standard), and it calls toupper(), so it
> probably works on single-bytes encodings, but not multi-byte ones. Is
> this correct? is there a way to do multi-byte toupper? Perhaps
> converting to wide characters and calling towupper()?
>
> ---------------------------------------------------------------------------
>
> Oleg Bartunov wrote:
>
>>On Mon, 11 Aug 2003, Bruce Momjian wrote:
>>
>>
>>>Not sure. I thought it would work.
>>>
>>
>>No, it doesn't works. Several people already complained about bad
>>unicode support. I recall Tatsuo comment some piece of code.
>>I have a little page http://www.sai.msu.su/~megera/postgres/utf8.html
>>about my experience with UTF8 and cyrillic.
>>
>>
>>
>>
>>>---------------------------------------------------------------------------
>>>
>>>Eugeny Balakhonov wrote:
>>>
>>>>Hello, all!
>>>>
>>>>I have a good question for PostgreSQL FAQ.
>>>>
>>>>How to use string functions (like UPPER()/LOWER()) for non-latin strings?
>>>>Why UPPER() function doesn't work with my UNICODE PostgreSQL database which contains non-latin characters (like cyrillic)?
>>>>How to make case insensetive search by text field which contains non-latin characters?
>>>>
>>>>Thanks for your answers!
>>>>
>>>>Best regards
>>>>Eugeny
>>>
>>>
>> Regards,
>> Oleg
>>_____________________________________________________________
>>Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
>>Sternberg Astronomical Institute, Moscow University (Russia)
>>Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
>>phone: +007(095)939-16-83, +007(095)939-23-83
>>
>
>
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2003-08-17 04:50 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Alexander Litvinov <lan@ac-sw.com>
0 siblings, 0 replies; 68+ messages in thread
From: Bruce Momjian @ 2003-08-17 04:50 UTC (permalink / raw)
To: Alexander Litvinov <lan@ac-sw.com>; +Cc: Eugeny Balakhonov <ccs@dubki.ru>; pgsql-general
Added to TODO:
* Fix upper()/lower() to work for multibyte encodings
---------------------------------------------------------------------------
Alexander Litvinov wrote:
[ PGP not available, raw data follows ]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I confirm this behavour: cyrilic words are not changed by lower()/upper()
> functions, nor catched by ilike.
>
> I am using :
> => SELECT version();
> version
> - ---------------------------------------------------------------
> PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2
> (1 row)
>
> Nothing special was done during database creation (no encoding selected).
>
> > Not sure. I thought it would work.
>
> > > How to use string functions (like UPPER()/LOWER()) for non-latin strings?
> > > Why UPPER() function doesn't work with my UNICODE PostgreSQL database
> > > which contains non-latin characters (like cyrillic)? How to make case
> > > insensetive search by text field which contains non-latin characters?
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.2 (GNU/Linux)
>
> iD8DBQE/Nw7wV+WKOINIfOYRAuhmAJwMEkdgqXkt6ZhgJsFZfQH2mELRwgCfeDeV
> L9TbSItEb0tAC7cI0cKwg6A=
> =veHN
> -----END PGP SIGNATURE-----
>
[ End of raw data]
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql/
@ 2006-01-23 11:01 A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 68+ messages in thread
From: A. Kretschmer @ 2006-01-23 11:01 UTC (permalink / raw)
To: pgsql-general
am 23.01.2006, um 11:38:28 +0100 mailte Janning Vygen folgendes:
> I would like to talk to some professional Postgresql DBA personally (preferred
> in german language). Of course we will pay for it. I don't want to talk to
> sells personal, i want to talk to someone who really knows and has lots of
http://www.credativ.de/
Peter Eisentraut and Michael Meskes, german PostgreSQL-Developers,
working there.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
^ permalink raw reply [nested|flat] 68+ messages in thread
* postgreSQL
@ 2007-02-17 04:37 jorge de la pena <jorpeav@prodigy.net.mx>
0 siblings, 3 replies; 68+ messages in thread
From: jorge de la pena @ 2007-02-17 04:37 UTC (permalink / raw)
To: pgsql-es-ayuda@postgresql.org
Hola a todos !
Tengo instalodo Debian 3.1, Quiero instalar una version superior
postgresql 8.1, la version de postgresql que dispongo de mi cd.
es postgresql 7.4.7.
Mi pregunta es solo puedo instalar postgresql en version tar
Les agradesco cualquier comentario o sugerencia!
Gracias
Jorge de la pena
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-17 06:00 Jaime Casanova <systemguards@gmail.com>
parent: jorge de la pena <jorpeav@prodigy.net.mx>
2 siblings, 2 replies; 68+ messages in thread
From: Jaime Casanova @ 2007-02-17 06:00 UTC (permalink / raw)
To: jorge de la pena <jorpeav@prodigy.net.mx>; +Cc: pgsql-es-ayuda@postgresql.org
On 2/16/07, jorge de la pena <jorpeav@prodigy.net.mx> wrote:
>
> Hola a todos !
>
> Tengo instalodo Debian 3.1, Quiero instalar una version superior
> postgresql 8.1, la version de postgresql que dispongo de mi cd.
> es postgresql 7.4.7.
> Mi pregunta es solo puedo instalar postgresql en version tar
>
no, en debian tambien puedes instalar desde unstable
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-17 11:00 Gabriel Colina <colina_movil@yahoo.com>
parent: Jaime Casanova <systemguards@gmail.com>
1 sibling, 1 reply; 68+ messages in thread
From: Gabriel Colina @ 2007-02-17 11:00 UTC (permalink / raw)
To: Jaime Casanova <systemguards@gmail.com>; jorge de la pena <jorpeav@prodigy.net.mx>; +Cc: pgsql-es-ayuda@postgresql.org
--- Jaime Casanova <systemguards@gmail.com> escribió:
> On 2/16/07, jorge de la pena
> <jorpeav@prodigy.net.mx> wrote:
> >
> > Hola a todos !
> >
> > Tengo instalodo Debian 3.1, Quiero instalar una
> version superior
> > postgresql 8.1, la version de postgresql que
> dispongo de mi cd.
> > es postgresql 7.4.7.
> > Mi pregunta es solo puedo instalar postgresql en
> version tar
> >
>
> no, en debian tambien puedes instalar desde unstable
>
> --
> Atentamente,
> Jaime Casanova
>
> "Programming today is a race between software
> engineers striving to
> build bigger and better idiot-proof programs and the
> universe trying
> to produce bigger and better idiots.
> So far, the universe is winning."
> Richard Cook
>
> ---------------------------(fin del
> mensaje)---------------------------
> TIP 2: puedes desuscribirte de todas las listas
> simultáneamente
> (envíe "unregister TuDirecciónDeCorreo" a
> majordomo@postgresql.org)
Jaime
Por un problema mas que de comodidad de filosofia
estoy por adoptar Debian, tengo que documentarme bien,
me han dicho que no es para neofitos de linux, que
mejor seria suse o mandrivia, pero me gusto mucho lo
que gunnar opina sobre el aspecto social del software
libre, entonces para mi casa voy a usar Debian.
Hoy por hoy uso las peores opciones segun la
comunidad, fedora y windows jeje, puesto que son
faciles de instalar para mi y puedo salir de un
problema en poco tiempo, pero de todas maneras
postgres es el punto fuerte y por eso sostengo, no
importa en que plataforma, usa postgres que igual te
va a rendir mas que el soft propietario.
Ahora bien el punto es que no se instalar ni
configurar, postgres en un debian y creo que en ningun
linux, por que ademas tengo que habilitar puerto y
hacer otras cosas.
Ademas necesito habilitar ssh o telnet para trabajar
con puty.
Donde me documento mejor.?? para hacer esta tarea.
Ademas te pido opinion sobre este punto
http://www.ghcolina.com/postgres_latam/
Punto del que hemos estado debatiendo bastante y que
creo que llego la hora de debatir para hacer.
Ademas de empezar a dar forma a una comision o algo
que se encargue del encuentro postgres-latam
Punto o puntos de encuentro, apoyos, de gobiernos,
organizaciones privadas, ongs, universidades, etc.
Espero respuesta.
Atte.
Gabriel Colina
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-17 12:58 Leonel Nunez <lnunez@enelserver.com>
parent: jorge de la pena <jorpeav@prodigy.net.mx>
2 siblings, 0 replies; 68+ messages in thread
From: Leonel Nunez @ 2007-02-17 12:58 UTC (permalink / raw)
To: jorge de la pena <jorpeav@prodigy.net.mx>; +Cc: pgsql-es-ayuda@postgresql.org
> Hola a todos !
>
> Tengo instalodo Debian 3.1, Quiero instalar una version superior
> postgresql 8.1, la version de postgresql que dispongo de mi cd.
> es postgresql 7.4.7.
> Mi pregunta es solo puedo instalar postgresql en version tar
>
> Les agradesco cualquier comentario o sugerencia!
>
> Gracias
>
> Jorge de la pena
>
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 8: explain analyze es tu amigo
>
Dale una leida por aqui :
http://www.postgresql.org/docs/8.2/interactive/install-short.html
Leonel
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-17 12:59 Leonel Nunez <lnunez@enelserver.com>
parent: Jaime Casanova <systemguards@gmail.com>
1 sibling, 1 reply; 68+ messages in thread
From: Leonel Nunez @ 2007-02-17 12:59 UTC (permalink / raw)
To: Jaime Casanova <systemguards@gmail.com>; +Cc: jorge de la pena <jorpeav@prodigy.net.mx>; pgsql-es-ayuda@postgresql.org
> On 2/16/07, jorge de la pena <jorpeav@prodigy.net.mx> wrote:
>>
>> Hola a todos !
>>
>> Tengo instalodo Debian 3.1, Quiero instalar una version superior
>> postgresql 8.1, la version de postgresql que dispongo de mi cd.
>> es postgresql 7.4.7.
>> Mi pregunta es solo puedo instalar postgresql en version tar
>>
>
> no, en debian tambien puedes instalar desde unstable
>
> --
> Atentamente,
> Jaime Casanova
>
>
Haciendo inestable el todo el lo que dependa de PostgreSQL
leonel
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-17 21:49 Jaime Casanova <systemguards@gmail.com>
parent: Leonel Nunez <lnunez@enelserver.com>
0 siblings, 1 reply; 68+ messages in thread
From: Jaime Casanova @ 2007-02-17 21:49 UTC (permalink / raw)
To: Leonel Nunez <lnunez@enelserver.com>; +Cc: jorge de la pena <jorpeav@prodigy.net.mx>; pgsql-es-ayuda@postgresql.org
On 2/17/07, Leonel Nunez <lnunez@enelserver.com> wrote:
> > On 2/16/07, jorge de la pena <jorpeav@prodigy.net.mx> wrote:
> >>
> >> Hola a todos !
> >>
> >> Tengo instalodo Debian 3.1, Quiero instalar una version superior
> >> postgresql 8.1, la version de postgresql que dispongo de mi cd.
> >> es postgresql 7.4.7.
> >> Mi pregunta es solo puedo instalar postgresql en version tar
> >>
> >
> > no, en debian tambien puedes instalar desde unstable
> >
> > --
> > Atentamente,
> > Jaime Casanova
> >
> >
>
> Haciendo inestable el todo el lo que dependa de PostgreSQL
>
nunca dije que fuera recomendable... solo que se podia... jeje
--
Atentamente,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-17 23:35 Leonel Nunez <lnunez@enelserver.com>
parent: Jaime Casanova <systemguards@gmail.com>
0 siblings, 0 replies; 68+ messages in thread
From: Leonel Nunez @ 2007-02-17 23:35 UTC (permalink / raw)
To: Jaime Casanova <systemguards@gmail.com>; +Cc: Leonel Nunez <lnunez@enelserver.com>; jorge de la pena <jorpeav@prodigy.net.mx>; pgsql-es-ayuda@postgresql.org
> On 2/17/07, Leonel Nunez <lnunez@enelserver.com> wrote:
>> > On 2/16/07, jorge de la pena <jorpeav@prodigy.net.mx> wrote:
>> >>
>> >> Hola a todos !
>> >>
>> >> Tengo instalodo Debian 3.1, Quiero instalar una version superior
>> >> postgresql 8.1, la version de postgresql que dispongo de mi cd.
>> >> es postgresql 7.4.7.
>> >> Mi pregunta es solo puedo instalar postgresql en version tar
>> >>
>> >
>> > no, en debian tambien puedes instalar desde unstable
>> >
>> > --
>> > Atentamente,
>> > Jaime Casanova
>> >
>> >
>>
>> Haciendo inestable el todo el lo que dependa de PostgreSQL
>>
>
> nunca dije que fuera recomendable... solo que se podia... jeje
>
> --
> Atentamente,
> Jaime Casanova
>
> "Programming today is a race between software engineers striving to
> build bigger and better idiot-proof programs and the universe trying
> to produce bigger and better idiots.
> So far, the universe is winning."
> Richard Cook
>
Asi es y en ese caso creo que es mejor usar todo el stack a partir del
source y mantenerlo uno mismo. Ya que en caso de actualizacion sabes que
debes mover antes de actualizar, en el caso de usar paquetes de unstable
en algo estable como sabemos puede romper algo y no sabemos cuanto tiempo
pasara en que se "desrompa" jeje
leonel
^ permalink raw reply [nested|flat] 68+ messages in thread
* RE: postgreSQL
@ 2007-02-19 14:52 Edwin Quijada <listas_quijada@hotmail.com>
parent: jorge de la pena <jorpeav@prodigy.net.mx>
2 siblings, 1 reply; 68+ messages in thread
From: Edwin Quijada @ 2007-02-19 14:52 UTC (permalink / raw)
To: jorpeav@prodigy.net.mx; +Cc: pgsql-es-ayuda@postgresql.org
> Hola a todos !
>
> Tengo instalodo Debian 3.1, Quiero instalar una version superior
> postgresql 8.1, la version de postgresql que dispongo de mi cd.
> es postgresql 7.4.7.
> Mi pregunta es solo puedo instalar postgresql en version tar
>
> Les agradesco cualquier comentario o sugerencia!
>
> Gracias
>
> Jorge de la pena
En los backports creo q esta la version 8.0.7. Al menos de ahi la instale
hace un tiempo.
>
>
>---------------------------(fin del mensaje)---------------------------
>TIP 8: explain analyze es tu amigo
_________________________________________________________________
¿Cuánto vale tu auto? Tips para mantener tu carro. ¡De todo en MSN Latino
Autos! http://latino.msn.com/autos/
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: postgreSQL
@ 2007-02-19 15:35 Edwin Quijada <listas_quijada@hotmail.com>
parent: Gabriel Colina <colina_movil@yahoo.com>
0 siblings, 0 replies; 68+ messages in thread
From: Edwin Quijada @ 2007-02-19 15:35 UTC (permalink / raw)
To: colina_movil@yahoo.com; +Cc: pgsql-es-ayuda@postgresql.org
Puedes usar debian sin nungun problema
Bajate el instalador desde internet que sea para instalar desde la red.
Preferiblemente el etch4
Lugo solo tienes q hacer apt-get update
y listo \
No es tan difiicil , la verdad creo q debian en estos momentos es de las
distro mas faciles.
Si tienes problemas solo avisame uso Suse y Debian.
>
>--- Jaime Casanova <systemguards@gmail.com> escribió:
>
> > On 2/16/07, jorge de la pena
> > <jorpeav@prodigy.net.mx> wrote:
> > >
>
> > --
> > Atentamente,
> > Jaime Casanova
> >
> > "Programming today is a race between software
> > engineers striving to
> > build bigger and better idiot-proof programs and the
> > universe trying
> > to produce bigger and better idiots.
> > So far, the universe is winning."
> > Richard Cook
> >
> > ---------------------------(fin del
> > mensaje)---------------------------
> > TIP 2: puedes desuscribirte de todas las listas
> > simultáneamente
> > (envíe "unregister TuDirecciónDeCorreo" a
> > majordomo@postgresql.org)
>Jaime
>
>Por un problema mas que de comodidad de filosofia
>estoy por adoptar Debian, tengo que documentarme bien,
>me han dicho que no es para neofitos de linux, que
>mejor seria suse o mandrivia, pero me gusto mucho lo
>que gunnar opina sobre el aspecto social del software
>libre, entonces para mi casa voy a usar Debian.
>Hoy por hoy uso las peores opciones segun la
>comunidad, fedora y windows jeje, puesto que son
>faciles de instalar para mi y puedo salir de un
>problema en poco tiempo, pero de todas maneras
>postgres es el punto fuerte y por eso sostengo, no
>importa en que plataforma, usa postgres que igual te
>va a rendir mas que el soft propietario.
>
>Ahora bien el punto es que no se instalar ni
>configurar, postgres en un debian y creo que en ningun
>linux, por que ademas tengo que habilitar puerto y
>hacer otras cosas.
>
>Ademas necesito habilitar ssh o telnet para trabajar
>con puty.
>
>Donde me documento mejor.?? para hacer esta tarea.
>
>Ademas te pido opinion sobre este punto
>
>http://www.ghcolina.com/postgres_latam/
>
>Punto del que hemos estado debatiendo bastante y que
>creo que llego la hora de debatir para hacer.
>
>Ademas de empezar a dar forma a una comision o algo
>que se encargue del encuentro postgres-latam
>
>Punto o puntos de encuentro, apoyos, de gobiernos,
>organizaciones privadas, ongs, universidades, etc.
>
>Espero respuesta.
>
>Atte.
>Gabriel Colina
>
>
>
>
>
>
>__________________________________________________
>Correo Yahoo!
>Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
>Regístrate ya - http://correo.espanol.yahoo.com/
>
>---------------------------(fin del mensaje)---------------------------
>TIP 9: el optimizador ignorará el uso de recorridos de índice si los
> tipos de datos de las columnas no coinciden
_________________________________________________________________
Latinos en EE.UU: noticias y artículos de interés para ti
http://latino.msn.com/noticias/latinoseneeuu
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: [pgsql-es-ayuda] postgreSQL
@ 2007-02-19 20:09 David Primero Segundo <aberracion2001@hotmail.com>
parent: Edwin Quijada <listas_quijada@hotmail.com>
0 siblings, 0 replies; 68+ messages in thread
From: David Primero Segundo @ 2007-02-19 20:09 UTC (permalink / raw)
To: pgsql-general
amigo en este enlace te explican paso a paso como instalar postgresql, yo
tengo debian e instale postgre 8.2.1 siguiendo los pasos de dicho link. a
ver que te parece:
http://www.postgresql.org.mx/?q=node/9
>From: "Edwin Quijada" <listas_quijada@hotmail.com>
>To: jorpeav@prodigy.net.mx
>CC: pgsql-es-ayuda@postgresql.org
>Subject: RE: [pgsql-es-ayuda] postgreSQL
>Date: Mon, 19 Feb 2007 14:52:00 +0000
>
>
>
>
>
>
>> Hola a todos !
>>
>> Tengo instalodo Debian 3.1, Quiero instalar una version superior
>> postgresql 8.1, la version de postgresql que dispongo de mi cd.
>> es postgresql 7.4.7.
>> Mi pregunta es solo puedo instalar postgresql en version tar
>>
>> Les agradesco cualquier comentario o sugerencia!
>>
>> Gracias
>>
>> Jorge de la pena
>
>En los backports creo q esta la version 8.0.7. Al menos de ahi la instale
>hace un tiempo.
>
>
>>
>>
>>---------------------------(fin del mensaje)---------------------------
>>TIP 8: explain analyze es tu amigo
>
>_________________________________________________________________
>¿Cuánto vale tu auto? Tips para mantener tu carro. ¡De todo en MSN Latino
>Autos! http://latino.msn.com/autos/
>
>
>---------------------------(fin del mensaje)---------------------------
>TIP 2: puedes desuscribirte de todas las listas simultáneamente
> (envíe "unregister TuDirecciónDeCorreo" a majordomo@postgresql.org)
_________________________________________________________________
Descarga gratis la Barra de Herramientas de MSN
http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU=http%3A//www.hotmail.com&...
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 2008-09-07 20:52 Mickey Shekdar <support@EF-USA.com>
0 siblings, 1 reply; 68+ messages in thread
From: Mickey Shekdar @ 2008-09-07 20:52 UTC (permalink / raw)
To: pgadmin-support@postgresql.org
<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Hello,</div>
<div> </div>
<div>We are switching our web booking engine vendor. The present vendor is using Microsoft SQL and the new vendor uses PostgreSQL.</div>
<div> </div>
<div>I have three questions and will appreciate your comments:</div>
<div> </div>
<div>[1] Will PostgreSQL perform better on Linux or Windows OS</div>
<div>[2] What is the best RAID configuration/number of dives you recommend</div>
<div>[3] Is there a hosting company offering fully monitored/managed PostgreSQL</div>
<div> </div>
<div>Your response will be highly appreciated</div>
<div> </div>
<div>Mickey Shekdar</div>
<div><STRONG><FONT color=#990000>718-980-6321</FONT></STRONG></div></span></body></html>
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2008-09-11 08:44 Tino Wildenhain <tino@wildenhain.de>
parent: Mickey Shekdar <support@EF-USA.com>
0 siblings, 1 reply; 68+ messages in thread
From: Tino Wildenhain @ 2008-09-11 08:44 UTC (permalink / raw)
To: Mickey Shekdar <support@EF-USA.com>; +Cc: pgsql-general
Mickey Shekdar wrote:
> Hello,
>
> We are switching our web booking engine vendor. The present vendor is
> using Microsoft SQL and the new vendor uses PostgreSQL.
>
> I have three questions and will appreciate your comments:
>
> [1] Will PostgreSQL perform better on Linux or Windows OS
The performance is better on Linux, last but not least because
it is developed and thus optimized there much longer then it
is natively available for windows. Also system management is a lot
more easy on unix like systems.
> [2] What is the best RAID configuration/number of dives you recommend
You should ask the vendor of your web booking engine, it really depends
much on the nature of the transactions. Also have a look in the archive
of the "postgresql general" - list, which is also much more appropriate
then this list here.
> [3] Is there a hosting company offering fully monitored/managed PostgreSQL
Yes, plenty. Please check the webpage of postgresql.org
Cheers
Tino Wildenhain
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: [GENERAL] PostgreSQL
@ 2008-09-15 04:32 Craig Ringer <craig@postnewspapers.com.au>
parent: Tino Wildenhain <tino@wildenhain.de>
0 siblings, 0 replies; 68+ messages in thread
From: Craig Ringer @ 2008-09-15 04:32 UTC (permalink / raw)
To: Tino Wildenhain <tino@wildenhain.de>; +Cc: Mickey Shekdar <support@EF-USA.com>; pgsql-general
Tino Wildenhain wrote:
>> [1] Will PostgreSQL perform better on Linux or Windows OS
>
> The performance is better on Linux, last but not least because
> it is developed and thus optimized there much longer then it
> is natively available for windows. Also system management is a lot
> more easy on unix like systems.
There are also a lot more PostgreSQL developers and users interested in
UNIX systems. While there appear to be lots of PostgreSQL users on
Windows now they don't seem to be very frequent contributors,
particularly active on the mailing lists, etc.
That's going to reduce the rate of PostgreSQL's improvement on Windows,
especially given how generally unpleasant the platform is to develop on*.
>> [2] What is the best RAID configuration/number of dives you recommend
>
> You should ask the vendor of your web booking engine, it really depends
> much on the nature of the transactions. Also have a look in the archive
> of the "postgresql general" - list, which is also much more appropriate
> then this list here.
The appropraite setup also depends on your controller's performance
characteristics, your particular workload, etc. If things are busy
enough you might even want to look at using tablespaces to split busy
tables on to separate volumes.
* Except Visual Studio's debugger, which I use a lot when I encounter
wacky problems in C++ code. gdb is OK for C, but awful for C++. It often
seems to be necessary to have two systems - a Linux one for valgrind and
everything else, plus a Windows one for VC++'s debugger.
--
Craig Ringer
^ permalink raw reply [nested|flat] 68+ messages in thread
* Postgresql
@ 2009-03-12 16:51 André Silva <cevola@hotmail.com>
0 siblings, 3 replies; 68+ messages in thread
From: André Silva @ 2009-03-12 16:51 UTC (permalink / raw)
To: pgsql-general
Hi
I've installed the postgresql in my computer but i've forgotten my password.
i've tried everything, i've been in your page that requires a e-mail to send information to reset the password but i never get the e-mail so far.(http://www.postgresql.org/community/lostpwd)
i've tried to make a new username but the ones that i've tried already exist.
What can i do? format my pc?
tell me something because i really need this
Best regards
André Silva
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2009-03-12 19:39 Raymond O'Donnell <rod@iol.ie>
parent: André Silva <cevola@hotmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Raymond O'Donnell @ 2009-03-12 19:39 UTC (permalink / raw)
To: André Silva <cevola@hotmail.com>; +Cc: pgsql-general
On 12/03/2009 16:51, André Silva wrote:
> I've installed the postgresql in my computer but i've forgotten my
> password.
Do you mean the password for the super-user account in PostgreSQL itself
(usually "postgres")? - or the password for the user account on the
machine under which PostgreSQL runs?
If it's the password for the PG superuser, and assuming that you've only
just installed PG and have no databases yet that you want to keep, you
could just scrub the installation and start again; do an initdb, or if
you're on Windows, uninstall and reinstall.
If you need to keep your installation, you could try what was suggested
in this post:
http://archives.postgresql.org/pgsql-general/2008-12/msg00700.php
If it's the user account password, a privileged user can reset it...what
OS are you on?
> i've tried everything, i've been in your page that requires a e-mail
> to send information to reset the password but i never get the e-mail
> so far.(http://www.postgresql.org/community/lostpwd)
That's not what you need - that's for community accounts which let you
do stuff on the the PostgreSQL website, wiki, etc.
> i've tried to
> make a new username but the ones that i've tried already exist. What
> can i do? format my pc?
Ouch! Definitely not that! :-)
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2009-03-12 19:40 Guy Rouillier <guyr-ml1@burntmail.com>
parent: André Silva <cevola@hotmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Guy Rouillier @ 2009-03-12 19:40 UTC (permalink / raw)
To: pgsql-general
André Silva wrote:
> Hi
> I've installed the postgresql in my computer but i've forgotten my password.
> i've tried everything, i've been in your page that requires a e-mail to
> send information to reset the password but i never get the e-mail so
> far.(http://www.postgresql.org/community/lostpwd)
> i've tried to make a new username but the ones that i've tried already
> exist.
> What can i do? format my pc?
> tell me something because i really need this
Well, you certainly don't need to reformat your PC. You didn't provide
much information that would enable people to help you, such as the
version of PostgreSQL, what if any customization you have already done,
if you've put things in your database you need access to, etc. In the
absence of all that, probably the quickest way for you to get access to
a database would be to simply create a new one.
A more descriptive subject to your emails would also encourage people to
respond.
--
Guy Rouillier
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2009-03-12 19:45 Andreas Kretschmer <akretschmer@spamfence.net>
parent: André Silva <cevola@hotmail.com>
2 siblings, 1 reply; 68+ messages in thread
From: Andreas Kretschmer @ 2009-03-12 19:45 UTC (permalink / raw)
To: pgsql-general
André Silva <cevola@hotmail.com> wrote:
> Hi
> I've installed the postgresql in my computer but i've forgotten my password.
> i've tried everything, i've been in your page that requires a e-mail to send
What have you tried exactly? And what error-messages you got?
> information to reset the password but i never get the e-mail so far.(http://
> www.postgresql.org/community/lostpwd)
This is for the email-list, not for the access to your db...
> i've tried to make a new username but the ones that i've tried already exist.
> What can i do? format my pc?
Depends.
> tell me something because i really need this
You can change (edit) your pg_hba.conf, setting the auth-method to
trust. But this is only a guess, because i don't know what you have
tried exactly and i don't know the error-message you got, never even
your operating system...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2009-03-12 19:56 Rich Shepard <rshepard@appl-ecosys.com>
parent: Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 1 reply; 68+ messages in thread
From: Rich Shepard @ 2009-03-12 19:56 UTC (permalink / raw)
To: pgsql-general
On Thu, 12 Mar 2009, Andreas Kretschmer wrote:
>> I've installed the postgresql in my computer but i've forgotten my password.
>> i've tried everything, i've been in your page that requires a e-mail to send
>> i've tried to make a new username but the ones that i've tried already exist.
>> What can i do? format my pc?
>
> Depends.
If the OP is running linux (or a *BSD), he can su to root and replace the
password for the preferred user (postgres, probably). The passwd program
will allow this. If the machine runs Microsoft, I've no idea at all since we
don't use any of that.
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com; Voice: 503-667-4517 Fax: 503-667-8863
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2009-03-12 20:02 Raymond O'Donnell <rod@iol.ie>
parent: Rich Shepard <rshepard@appl-ecosys.com>
0 siblings, 1 reply; 68+ messages in thread
From: Raymond O'Donnell @ 2009-03-12 20:02 UTC (permalink / raw)
To: Rich Shepard <rshepard@appl-ecosys.com>; +Cc: pgsql-general
On 12/03/2009 19:56, Rich Shepard wrote:
> will allow this. If the machine runs Microsoft, I've no idea at all
Start Menu
-> Administrative Tools
-> Computer Management
-> Local Users & Groups
-> Users
...then right-click on the user, and select "Set password".
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2009-03-12 20:39 John R Pierce <pierce@hogranch.com>
parent: Raymond O'Donnell <rod@iol.ie>
0 siblings, 0 replies; 68+ messages in thread
From: John R Pierce @ 2009-03-12 20:39 UTC (permalink / raw)
To: pgsql-general
Raymond O'Donnell wrote:
> On 12/03/2009 19:56, Rich Shepard wrote:
>
>
>> will allow this. If the machine runs Microsoft, I've no idea at all
>>
>
> Start Menu
> -> Administrative Tools
> -> Computer Management
> -> Local Users & Groups
> -> Users
>
> ...then right-click on the user, and select "Set password".
>
or, at a Windows command line prompt, (of course, replacing newpassword
with whatever random password you chose)
C:\> net user postgres newpassword
then make sure the pgsql-8.3 (or whatever) service descriptor is using
this same password...
C:\> net user postgres newpassword
The command completed successfully.
C:\> sc config pgsql-8.3 password= mumba$$
[SC] ChangeServiceConfig SUCCESS
C:\> net start pgsql-8.3
The PostgreSQL Database Server 8.3 service is starting.
The PostgreSQL Database Server 8.3 service was started successfully.
(note on the SC CONFIG command, the spacing is critical on that
password= ... there's no space before the = and there must be a space
after it, quirky little thing)
^ permalink raw reply [nested|flat] 68+ messages in thread
* Postgresql
@ 2018-08-19 17:53 Sonam Sharma <sonams1209@gmail.com>
0 siblings, 2 replies; 68+ messages in thread
From: Sonam Sharma @ 2018-08-19 17:53 UTC (permalink / raw)
To: pgsql-general
I am planning to migrate my db from db2 to postgresql. Before that I wanted
to know is postgresql better than db2? Is it completely free ? Any
performance issues or any limitations?
Attachments:
icon.png (image/png, 1.4K) download
view image
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2018-08-19 17:55 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Sonam Sharma <sonams1209@gmail.com>
1 sibling, 1 reply; 68+ messages in thread
From: Adrian Klaver @ 2018-08-19 17:55 UTC (permalink / raw)
To: Sonam Sharma <sonams1209@gmail.com>; pgsql-general
On 08/19/2018 10:53 AM, Sonam Sharma wrote:
>
>
>
>
> I am planning to migrate my db from db2 to postgresql. Before that I
> wanted to know is postgresql better than db2? Is it completely free ?
> Any performance issues or any limitations?
Yes, yes, depends
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2018-08-19 17:56 Sonam Sharma <sonams1209@gmail.com>
parent: Adrian Klaver <adrian.klaver@aklaver.com>
0 siblings, 3 replies; 68+ messages in thread
From: Sonam Sharma @ 2018-08-19 17:56 UTC (permalink / raw)
To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general
Thank you! Can you please help me with any advantages/disadvantages.. my db
size is less than 10gb. I am very new to this.
On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:
> On 08/19/2018 10:53 AM, Sonam Sharma wrote:
> >
> >
> >
> >
> > I am planning to migrate my db from db2 to postgresql. Before that I
> > wanted to know is postgresql better than db2? Is it completely free ?
> > Any performance issues or any limitations?
>
> Yes, yes, depends
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2018-08-19 18:00 Adrian Klaver <adrian.klaver@aklaver.com>
parent: Sonam Sharma <sonams1209@gmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Adrian Klaver @ 2018-08-19 18:00 UTC (permalink / raw)
To: Sonam Sharma <sonams1209@gmail.com>; +Cc: pgsql-general
On 08/19/2018 10:56 AM, Sonam Sharma wrote:
> Thank you! Can you please help me with any advantages/disadvantages.. my
> db size is less than 10gb. I am very new to this.
I would start here:
https://www.postgresql.org/about/
>
> On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 08/19/2018 10:53 AM, Sonam Sharma wrote:
> >
> >
> >
> >
> > I am planning to migrate my db from db2 to postgresql. Before that I
> > wanted to know is postgresql better than db2? Is it completely
> free ?
> > Any performance issues or any limitations?
>
> Yes, yes, depends
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2018-08-19 18:01 Christophe Pettus <xof@thebuild.com>
parent: Sonam Sharma <sonams1209@gmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Christophe Pettus @ 2018-08-19 18:01 UTC (permalink / raw)
To: Sonam Sharma <sonams1209@gmail.com>; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general
> On Aug 19, 2018, at 10:56, Sonam Sharma <sonams1209@gmail.com> wrote:
>
> Thank you! Can you please help me with any advantages/disadvantages.. my db size is less than 10gb. I am very new to this.
That's a topic far too broad for a simple mailing list thread. PostgreSQL is extremely feature-complete, but how it performs on any particular database will vary considerably.
The good news is that for a database of that size, it's easy to install it and test it against your workload. That's really the only practical way of telling if it will be suitable for you.
--
-- Christophe Pettus
xof@thebuild.com
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2018-08-19 18:37 Chris Travers <chris.travers@gmail.com>
parent: Sonam Sharma <sonams1209@gmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Chris Travers @ 2018-08-19 18:37 UTC (permalink / raw)
To: sonams1209@gmail.com; +Cc: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general
On Sun, Aug 19, 2018 at 7:57 PM Sonam Sharma <sonams1209@gmail.com> wrote:
> Thank you! Can you please help me with any advantages/disadvantages.. my
> db size is less than 10gb. I am very new to this.
>
At 10GB you are unlikely to hit performance limitations that make you think
about how to use PostgreSQL more effectively. You will have to avoid doing
the sorts of things you want to avoid doing on all databases.
DB2 and PostgreSQL are both very feature-rich databases but in somewhat
different directions. For example, DB2 has more storage options than
PostgreSQL does. But again at 10GB it is unlikely you will have to worry
about these.
Where PostgreSQL really shines is in generally workload tuning and
programmability. Especially programmability. PostgreSQL is extremely
extensible and this means not only can you build your own extensions for
whatever you need to do (assuming some skill) but there are tons of
extensions you can use for free including great ones like PostGIS.
Generally you can expect at 10GB to have to avoid needless complexity like
repeated sequential scans. Indexing becomes a bit important. By 100GB you
have to pay significant attention to index strategies and disk access. I
am aware of single databases of up to 50TB in size used in production and
federated storage environments into the petabytes.
In general I can think of no reason not to use PostgreSQL unless your
salary depends on paying license fees....
>
> On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <adrian.klaver@aklaver.com>
> wrote:
>
>> On 08/19/2018 10:53 AM, Sonam Sharma wrote:
>> >
>> >
>> >
>> >
>> > I am planning to migrate my db from db2 to postgresql. Before that I
>> > wanted to know is postgresql better than db2? Is it completely free ?
>> > Any performance issues or any limitations?
>>
>> Yes, yes, depends
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com
>>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: Postgresql
@ 2018-09-25 20:16 pinker <pinker@onet.eu>
parent: Sonam Sharma <sonams1209@gmail.com>
1 sibling, 0 replies; 68+ messages in thread
From: pinker @ 2018-09-25 20:16 UTC (permalink / raw)
To: pgsql-general
You might find this comparision useful:
https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
^ permalink raw reply [nested|flat] 68+ messages in thread
* PostgreSQL
@ 2023-02-07 11:02 Joseph Kennedy <joseph.kennedy.486@gmail.com>
0 siblings, 3 replies; 68+ messages in thread
From: Joseph Kennedy @ 2023-02-07 11:02 UTC (permalink / raw)
To: pgsql-general
I would like restrict access to sensitive or restricted information for some users (eg. hide data of one or more clients for some database users).
PostgreSQL allows to create security policy as Row-Level Security, policies based on the querying user.
Are there any other alternatives to RLS, are there any better solutions??
What are the advantages and disadvantages of RLS?
How much RLS will cause a decrease in database performance?
JK
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 11:10 Thomas Kellerer <shammat@gmx.net>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Thomas Kellerer @ 2023-02-07 11:10 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Joseph Kennedy schrieb am 07.02.2023 um 12:02:
> I would like restrict access to sensitive or restricted information
> for some users (eg. hide data of one or more clients for some
> database users).
>
> PostgreSQL allows to create security policy as Row-Level Security,
> policies based on the querying user.
>
>
> Are there any other alternatives to RLS, are there any better
> solutions??
You can create a view layer and only grant access to the data through views
(and obviously revoke access to the tables directly)
Or allow access only through (set returning) functions
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 11:15 Giovanni Biscontini <biscontini.g@es2000.it>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
2 siblings, 1 reply; 68+ messages in thread
From: Giovanni Biscontini @ 2023-02-07 11:15 UTC (permalink / raw)
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>; +Cc: pgsql-general
Hi Joseph,
one way to filter without RLS is using functions to make queries:
this way you can cross check input parameters with login user (= user
issuing query). Using functions slow an execution but incapsulate query
letting you be able even to parse input parameters and filter results.
Sorry but I have no time ref for RLS, and remember that before you can use
RLS you must enable it on the table you want to use in.
best regards, Giovanni
Il giorno mar 7 feb 2023 alle ore 12:02 Joseph Kennedy <
joseph.kennedy.486@gmail.com> ha scritto:
> I would like restrict access to sensitive or restricted information for
> some users (eg. hide data of one or more clients for some database users).
>
> PostgreSQL allows to create security policy as Row-Level Security,
> policies based on the querying user.
>
>
> Are there any other alternatives to RLS, are there any better solutions??
>
> What are the advantages and disadvantages of RLS?
>
> How much RLS will cause a decrease in database performance?
>
> JK
>
>
>
>
>
--
*Cordiali Saluti*
*Dott. Giovanni Biscontini*
* [Divisone Software]*
*Str. Ponte Alto Sud, 74 41123 Modena (MO)*
Phone: 059_452094
Fax: 059_8672171
E-mail: biscontini.g@es2000.it
Skype: g.biscontini.eurosystem2000
WEB: https://www.es2000.it <http://www.es2000.it/;
____________________________________
Privacy e riservatezza: il presente messaggio, così come i relativi
allegati, contengono dati ed informazioni da considerarsi strettamente
riservate ed è indirizzato esclusivamente al destinatario sopra indicato,
il quale è l'unico autorizzato a trattarlo in osservanza delle norme del
Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo
messaggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a
terzi e di dare notizia al mittente dell’errato invio, distruggendone poi
l'eventuale copia cartacea e la copia in formato elettronico.
Il titolare dei dati potrà esercitare tutti i diritti di cui all'art.7 del
suddetto decreto tra cui quelli di accesso, rettifica, aggiornamento,
opposizione al trattamento e cancellazione
*Please, print this e-mail only if necessary*
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 11:36 Joseph Kennedy <joseph.kennedy.486@gmail.com>
parent: Giovanni Biscontini <biscontini.g@es2000.it>
0 siblings, 3 replies; 68+ messages in thread
From: Joseph Kennedy @ 2023-02-07 11:36 UTC (permalink / raw)
To: Giovanni Biscontini <biscontini.g@es2000.it>; +Cc: pgsql-general
--Apple-Mail-E4E0FA72-EF30-4F11-B470-9A18A8159B05
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">RLS policy it only affects to command as SE=
LECT, INSERT, UPDATE, DELETE or can affects to operations on whole database,=
table like vacuum or reindex etc ?<br><div dir=3D"ltr"><br><blockquote type=
=3D"cite">Wiadomo=C5=9B=C4=87 napisana przez Giovanni Biscontini <biscont=
ini.g@es2000.it> w dniu 07.02.2023, o godz. 12:16:<br><br></blo=
ckquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D=
"ltr">Hi Joseph,<div> one way to filter without RLS is using fun=
ctions to make queries:</div><div>this way you can cross check input paramet=
ers with login user (=3D user issuing query). Using functions slow=
an execution but incapsulate query letting you be able even to parse input p=
arameters and filter results. Sorry but I have no time ref for RLS, and reme=
mber that before you can use RLS you must enable it on the table you want to=
use in.</div><div>best regards, Giovanni</div></div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">Il giorno mar 7 feb 2023 alle o=
re 12:02 Joseph Kennedy <<a href=3D"mailto:joseph.kennedy.486@gmail.com">=
joseph.kennedy.486@gmail.com</a>> ha scritto:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">I would like restrict access to sensitive or re=
stricted information for some users (eg. hide data of one or more clients fo=
r some database users).<br>
<br>
PostgreSQL allows to create security policy as Row-Level Security, policies b=
ased on the querying user.<br>
<br>
<br>
Are there any other alternatives to RLS, are there any better solutions??<br=
>
<br>
What are the advantages and disadvantages of RLS?<br>
<br>
How much RLS will cause a decrease in database performance?<br>
<br>
JK<br>
<br>
<br>
<br>
<br>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr" c=
lass=3D"gmail_signature"><div dir=3D"ltr"><p class=3D"MsoNormal" style=3D"li=
ne-height:normal"><span style=3D"font-size:12pt"> </span><span></span><=
/p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:12pt"> </span><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b>Cordiali Saluti</b><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span></span></p><p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt=
;line-height:normal"><img src=3D"https://ci3.googleusercontent.com/mail-sig/=
AIorK4wW12ZNDdF_BcmKN6zTAWE_BVey5jo0Vjx6DCd3Lh8QNf7OZ5pyIuCt8HHiwcR0LNmBay9N=
P-Y" data-unique-identifier=3D""><br></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b> </b><b><span style=3D"font-size:13pt;font-family:Arial,sans-serif">D=
ott. Giovanni Biscontini</span></b><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b><span style=3D"font-size:12pt;font-family:Arial,sans-serif"> [Divison=
e
Software]</span></b><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b><span style=3D"font-size:13pt;color:black"> </span></b><b><span style=
=3D"font-size:10pt;font-family:Arial,sans-serif">Str. Ponte Alto Sud, 74&nbs=
p;<br>
41123 Modena (MO)</span></b><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal">&=
nbsp;<span lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-ser=
if">Phone:
059_452094 <br>
Fax: 059_8672171<br>
E-mail: </span><a href=3D"mailto:biscontini.g@es2000.it" target=3D"_bl=
ank">biscontini.g@es2000.it</a><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-serif">&n=
bsp;Skype: g.biscontini.eurosystem2000</span><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt;font-family:Arial,sans-serif"> </span><spa=
n lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-serif">WEB: <=
/span><a href=3D"http://www.es2000.it/"; title=3D"blocked::http://www.es2000.=
it/ http://www.es2000.it"; target=3D"_blank"><span lang=3D"EN-GB" style=3D"fo=
nt-size:10pt;font-family:Arial,sans-serif">https://www.es2000.it</span></a><=
span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span lang=3D"EN-GB" style=3D"font-size:10pt;font-family:Arial,sans-serif">&n=
bsp;</span><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt;font-family:Arial,sans-serif"> </span><spa=
n></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12pt;line-height:normal"><span=
style=3D"color:black"> </span><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt">____________________________________</span><sp=
an></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt;font-family:Times,serif">Privacy e
riservatezza: il presente messaggio, cos=C3=AC come i relativi allegati, con=
tengono
dati ed informazioni da considerarsi strettamente riservate ed =C3=A8 indiri=
zzato
esclusivamente al destinatario sopra indicato, il quale =C3=A8 l'unico autor=
izzato a
trattarlo in osservanza delle norme del Regolamento UE 2016/679 (RGPD) .
Preghiamo chiunque ricevesse questo messaggio per errore di evitare di
copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente
dell=E2=80=99errato invio, distruggendone poi l'eventuale copia cartacea e l=
a copia in
formato elettronico.</span><span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
span style=3D"font-size:10pt">Il titolare dei dati potr=C3=A0 esercitare tut=
ti i
diritti di cui all'art.7 del suddetto decreto tra cui quelli di accesso,
rettifica, aggiornamento, opposizione al trattamento e cancellazione</span><=
span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:0.0001pt;line-height:normal"><=
b><span lang=3D"EN-US" style=3D"font-size:8pt">Please, print this
e-mail only if necessary</span></b><span></span></p></div></div>
</div></blockquote></body></html>=
--Apple-Mail-E4E0FA72-EF30-4F11-B470-9A18A8159B05--
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 13:19 Giovanni Biscontini <biscontini.g@es2000.it>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Giovanni Biscontini @ 2023-02-07 13:19 UTC (permalink / raw)
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>; +Cc: pgsql-general
Hi,
RLS rely on Create policy command:
https://www.postgresql.org/docs/15/sql-createpolicy.html
it need a table_name, only
Il giorno mar 7 feb 2023 alle ore 12:37 Joseph Kennedy <
joseph.kennedy.486@gmail.com> ha scritto:
> RLS policy it only affects to command as SELECT, INSERT, UPDATE, DELETE or
> can affects to operations on whole database, table like vacuum or reindex
> etc ?
>
> Wiadomość napisana przez Giovanni Biscontini <biscontini.g@es2000.it>
> w dniu 07.02.2023, o godz. 12:16:
>
>
> Hi Joseph,
> one way to filter without RLS is using functions to make queries:
> this way you can cross check input parameters with login user (= user
> issuing query). Using functions slow an execution but incapsulate query
> letting you be able even to parse input parameters and filter results.
> Sorry but I have no time ref for RLS, and remember that before you can use
> RLS you must enable it on the table you want to use in.
> best regards, Giovanni
>
> Il giorno mar 7 feb 2023 alle ore 12:02 Joseph Kennedy <
> joseph.kennedy.486@gmail.com> ha scritto:
>
>> I would like restrict access to sensitive or restricted information for
>> some users (eg. hide data of one or more clients for some database users).
>>
>> PostgreSQL allows to create security policy as Row-Level Security,
>> policies based on the querying user.
>>
>>
>> Are there any other alternatives to RLS, are there any better solutions??
>>
>> What are the advantages and disadvantages of RLS?
>>
>> How much RLS will cause a decrease in database performance?
>>
>> JK
>>
>>
>>
>>
>>
>
>
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 14:34 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
2 siblings, 1 reply; 68+ messages in thread
From: Laurenz Albe @ 2023-02-07 14:34 UTC (permalink / raw)
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>; Giovanni Biscontini <biscontini.g@es2000.it>; +Cc: pgsql-general
On Tue, 2023-02-07 at 12:36 +0100, Joseph Kennedy wrote:
> RLS policy it only affects to command as SELECT, INSERT, UPDATE, DELETE or
> can affects to operations on whole database, table like vacuum or reindex etc ?
No, that wouldn't make any sense. Row Level Security determines who
is allowed to see or create which data. Jobs like removing dead tuples
or rebuilding an index have nothing to do with that.
Besides, anything that requires the table owner or a superuser cannot
be reasonably controlled with row level security, because both the
table owner and a superuser are exempt from RLS anyway.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 14:46 Joseph Kennedy <joseph.kennedy.486@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 68+ messages in thread
From: Joseph Kennedy @ 2023-02-07 14:46 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general
Thank you Laurenz, I just wanted to make sure.
Do you know any alternative solution to RLS ?
> Wiadomość napisana przez Laurenz Albe <laurenz.albe@cybertec.at> w dniu 07.02.2023, o godz. 15:34:
>
> On Tue, 2023-02-07 at 12:36 +0100, Joseph Kennedy wrote:
>> RLS policy it only affects to command as SELECT, INSERT, UPDATE, DELETE or
>> can affects to operations on whole database, table like vacuum or reindex etc ?
>
> No, that wouldn't make any sense. Row Level Security determines who
> is allowed to see or create which data. Jobs like removing dead tuples
> or rebuilding an index have nothing to do with that.
>
> Besides, anything that requires the table owner or a superuser cannot
> be reasonably controlled with row level security, because both the
> table owner and a superuser are exempt from RLS anyway.
>
> Yours,
> Laurenz Albe
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 21:42 Peter J. Holzer <hjp-pgsql@hjp.at>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
2 siblings, 0 replies; 68+ messages in thread
From: Peter J. Holzer @ 2023-02-07 21:42 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
On 2023-02-07 12:36:57 +0100, Joseph Kennedy wrote:
> RLS policy it only affects to command as SELECT, INSERT, UPDATE, DELETE or can
> affects to operations on whole database, table like vacuum or reindex etc ?
"Row level security" works, as the name implies at the row level.
Tables, schemas and databases and covered by the "usual" SQL privilege
system.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-07 23:42 Brad White <b55white@gmail.com>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
2 siblings, 1 reply; 68+ messages in thread
From: Brad White @ 2023-02-07 23:42 UTC (permalink / raw)
To: ; +Cc: pgsql-general
I'm setting my options for my DNS-less connection using
https://odbc.postgresql.org/docs/config.html
and
https://odbc.postgresql.org/docs/config-opt.html
I found it interesting that the sample at the bottom of the first page had
options that don't exist on the second page.
Namely, B4, B5, D4. I hope those are not important.
The second page has options that are nowhere mentioned on the first page,
and vice-versa.
"Recognize unique indexes" is there as "UniqueIndex", but no indication of
the proper keyword to include it in the connection string.
CX - Abbreviate doesn't seem to have a corresponding entry in the
descriptions on page 1, and from some of the samples I found, seems like a
bit field, but no indication of possible options to use.
And lastly, one of the ODBC dialog boxes I saw had a checkbox for Keyset
query optimization, but no discussion on either page.
Same with Distributed Transaction settings.
Seems like, in an ideal world, there would be one page with the
description and that description would include the keyword and possible
options for each setting.
Thanks,
Brad.
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-08 00:11 Brad White <b55white@gmail.com>
parent: Brad White <b55white@gmail.com>
0 siblings, 0 replies; 68+ messages in thread
From: Brad White @ 2023-02-08 00:11 UTC (permalink / raw)
To: ; +Cc: pgsql-general
Sorry about the reply failure. I was trying to start a new thread and
failed.
On Tue, Feb 7, 2023 at 5:42 PM Brad White <b55white@gmail.com> wrote:
> I'm setting my options for my DNS-less connection using
> https://odbc.postgresql.org/docs/config.html
> and
> https://odbc.postgresql.org/docs/config-opt.html
>
> I found it interesting that the sample at the bottom of the first page had
> options that don't exist on the second page.
> Namely, B4, B5, D4. I hope those are not important.
>
> The second page has options that are nowhere mentioned on the first page,
> and vice-versa.
>
> "Recognize unique indexes" is there as "UniqueIndex", but no indication of
> the proper keyword to include it in the connection string.
>
> CX - Abbreviate doesn't seem to have a corresponding entry in the
> descriptions on page 1, and from some of the samples I found, seems like a
> bit field, but no indication of possible options to use.
>
> And lastly, one of the ODBC dialog boxes I saw had a checkbox for Keyset
> query optimization, but no discussion on either page.
> Same with Distributed Transaction settings.
>
> Seems like, in an ideal world, there would be one page with the
> description and that description would include the keyword and possible
> options for each setting.
>
> Thanks,
> Brad.
>
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-08 00:35 Stephen Frost <sfrost@snowman.net>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
0 siblings, 1 reply; 68+ messages in thread
From: Stephen Frost @ 2023-02-08 00:35 UTC (permalink / raw)
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general
Greetings,
* Joseph Kennedy (joseph.kennedy.486@gmail.com) wrote:
> Thank you Laurenz, I just wanted to make sure.
>
> Do you know any alternative solution to RLS ?
... to do what? If you want to limit the set of rows that a given user
can see, RLS is how to do that. If you want to limit the schemas or
tables that a user can see, that isn't possible in PG today (though
there was some interest a while back in making that work via RLS on the
catalogs which you might be able to find).
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-09 08:54 Joseph Kennedy <joseph.kennedy.486@gmail.com>
parent: Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 68+ messages in thread
From: Joseph Kennedy @ 2023-02-09 08:54 UTC (permalink / raw)
To: Stephen Frost <sfrost@snowman.net>; +Cc: Laurenz Albe <laurenz.albe@cybertec.at>; Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general
As I wtote, I would like restrict access to sensitive or restricted information for some users (eg. hide data of one or more clients for some database users).
My question is: do you know some other solution to do that ?
Some 3rd party solution eg. similar to pgpool or something else ?
Maybe RLS is the beat solution for me.
Thank you for your suggestions.
> Wiadomość napisana przez Stephen Frost <sfrost@snowman.net> w dniu 08.02.2023, o godz. 01:36:
>
> Greetings,
>
> * Joseph Kennedy (joseph.kennedy.486@gmail.com) wrote:
>> Thank you Laurenz, I just wanted to make sure.
>>
>> Do you know any alternative solution to RLS ?
>
> ... to do what? If you want to limit the set of rows that a given user
> can see, RLS is how to do that. If you want to limit the schemas or
> tables that a user can see, that isn't possible in PG today (though
> there was some interest a while back in making that work via RLS on the
> catalogs which you might be able to find).
>
> Thanks,
>
> Stephen
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-02-09 15:42 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
0 siblings, 1 reply; 68+ messages in thread
From: Laurenz Albe @ 2023-02-09 15:42 UTC (permalink / raw)
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>; Stephen Frost <sfrost@snowman.net>; +Cc: Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general
On Thu, 2023-02-09 at 09:54 +0100, Joseph Kennedy wrote:
> As I wtote, I would like restrict access to sensitive or restricted information
> for some users (eg. hide data of one or more clients for some database users).
>
> My question is: do you know some other solution to do that ?
It is easy to hide data from users: use permissions or row level security.
It is impossible to hide metadata from users, but we don't consider that a problem.
If you want that, use a database or a database cluster per user.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-04-02 21:21 Joseph Kennedy <joseph.kennedy.486@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 68+ messages in thread
From: Joseph Kennedy @ 2023-04-02 21:21 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Stephen Frost <sfrost@snowman.net>; Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general
> Wiadomość napisana przez Laurenz Albe <laurenz.albe@cybertec.at> w dniu 09.02.2023, o godz. 16:42:
>
> On Thu, 2023-02-09 at 09:54 +0100, Joseph Kennedy wrote:
>> As I wtote, I would like restrict access to sensitive or restricted information
>> for some users (eg. hide data of one or more clients for some database users).
>>
>> My question is: do you know some other solution to do that ?
>
> It is easy to hide data from users: use permissions or row level security.
>
> It is impossible to hide metadata from users, but we don't consider that a problem.
>
> If you want that, use a database or a database cluster per user.
>
> Yours,
> Laurenz Albe
I have one more question on this topic regarding Row Level Security.
I would like to hide some rows for users who should have full rights to database eg. create Index, drop table, create tabel etc. but e.g. create index can be done by owner or superusers but they are bypassed by Row Level Security.
Is possible to use RLS for users who should have full rights to database ?
^ permalink raw reply [nested|flat] 68+ messages in thread
* Re: PostgreSQL
@ 2023-04-03 09:45 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Joseph Kennedy <joseph.kennedy.486@gmail.com>
0 siblings, 0 replies; 68+ messages in thread
From: Laurenz Albe @ 2023-04-03 09:45 UTC (permalink / raw)
To: Joseph Kennedy <joseph.kennedy.486@gmail.com>; +Cc: Stephen Frost <sfrost@snowman.net>; Giovanni Biscontini <biscontini.g@es2000.it>; pgsql-general
On Sun, 2023-04-02 at 23:21 +0200, Joseph Kennedy wrote:
> I have one more question on this topic regarding Row Level Security.
>
> I would like to hide some rows for users who should have full rights to database
> eg. create Index, drop table, create tabel etc. but e.g. create index can be
> done by owner or superusers but they are bypassed by Row Level Security.
>
> Is possible to use RLS for users who should have full rights to database ?
If "full rights" implies dropping tables, the user must either be the owner
of these tables or a superuser. You cannot use Row Level Security with a
superuser. You can use ALTER TABLE ... FORCE ROW LEVEL SECURITY, so that
Row Level Security applies to the table owner as well, but you cannot keep
the owner from disabling that setting.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 68+ messages in thread
end of thread, other threads:[~2023-04-03 09:45 UTC | newest]
Thread overview: 68+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-16 09:51 Re: postgresql Geoff Keating <geoffk@ozemail.com.au>
1999-08-11 19:01 postgresql jeremy@xxedgexx.com
1999-10-07 13:10 PostgreSQL Allan Huffman <huffmana@ppc.pims.org>
1999-11-02 15:47 PostgreSQL HK Woo <hung_kai_woo@hotmail.com>
1999-11-02 18:56 ` Re: PostgreSQL zris <zris@somewhere.com>
1999-11-26 23:12 ` Re: PostgreSQL Matthew Leo <matt@acrcorp.removethis.com>
1999-11-26 15:49 PostgreSQL Horaci Cuevas <hcuevas@perti.com>
2000-06-07 14:39 Postgresql Mihai Gheorghiu <tanhq@bigplanet.com>
2000-06-07 19:57 ` Re: Postgresql Bruce Momjian <pgman@candle.pha.pa.us>
2000-06-07 20:07 ` Re: Postgresql Vince Vielhaber <vev@michvhf.com>
2000-06-07 21:29 ` Re: Postgresql Jim Jennis <jhjennis@shentel.net>
2000-06-08 02:56 ` Re: Postgresql Tom Dryden <tdryden@earthlink.net>
2000-06-08 12:49 ` Re: Postgresql The Hermit Hacker <scrappy@hub.org>
2000-09-29 17:10 Re: postgresql Tim Kientzle <kientzle@acm.org>
2003-03-26 18:06 PostgreSQL Camarao, Wagner (v) <Wagner.Camarao@bowneglobal.com.br>
2003-06-26 22:09 PostgreSQL Ulisses Ponticelli Giorgi <ulisses@compus.com.br>
2003-07-01 23:36 ` Re: PostgreSQL DeJuan Jackson <djackson@speedfc.com>
2003-07-02 06:01 ` Re: PostgreSQL Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
2003-08-10 15:58 PostgreSQL Eugeny Balakhonov <ccs@dubki.ru>
2003-08-11 04:01 ` Re: PostgreSQL Bruce Momjian <pgman@candle.pha.pa.us>
2003-08-11 03:35 ` Re: PostgreSQL Alexander Litvinov <lan@ac-sw.com>
2003-08-17 04:50 ` Re: PostgreSQL Bruce Momjian <pgman@candle.pha.pa.us>
2003-08-11 08:33 ` Re: PostgreSQL Oleg Bartunov <oleg@sai.msu.su>
2003-08-11 21:44 ` Re: PostgreSQL Bruce Momjian <pgman@candle.pha.pa.us>
2003-08-11 22:28 ` Re: PostgreSQL Dennis Gearon <gearond@cvc.net>
2006-01-23 11:01 Re: Postgresql/ A. Kretschmer <andreas.kretschmer@schollglas.com>
2007-02-17 04:37 postgreSQL jorge de la pena <jorpeav@prodigy.net.mx>
2007-02-17 06:00 ` Re: postgreSQL Jaime Casanova <systemguards@gmail.com>
2007-02-17 11:00 ` Re: postgreSQL Gabriel Colina <colina_movil@yahoo.com>
2007-02-19 15:35 ` Re: postgreSQL Edwin Quijada <listas_quijada@hotmail.com>
2007-02-17 12:59 ` Re: postgreSQL Leonel Nunez <lnunez@enelserver.com>
2007-02-17 21:49 ` Re: postgreSQL Jaime Casanova <systemguards@gmail.com>
2007-02-17 23:35 ` Re: postgreSQL Leonel Nunez <lnunez@enelserver.com>
2007-02-17 12:58 ` Re: postgreSQL Leonel Nunez <lnunez@enelserver.com>
2007-02-19 14:52 ` RE: postgreSQL Edwin Quijada <listas_quijada@hotmail.com>
2007-02-19 20:09 ` Re: [pgsql-es-ayuda] postgreSQL David Primero Segundo <aberracion2001@hotmail.com>
2008-09-07 20:52 PostgreSQL Mickey Shekdar <support@EF-USA.com>
2008-09-11 08:44 ` Re: PostgreSQL Tino Wildenhain <tino@wildenhain.de>
2008-09-15 04:32 ` Re: [GENERAL] PostgreSQL Craig Ringer <craig@postnewspapers.com.au>
2009-03-12 16:51 Postgresql André Silva <cevola@hotmail.com>
2009-03-12 19:39 ` Re: Postgresql Raymond O'Donnell <rod@iol.ie>
2009-03-12 19:40 ` Re: Postgresql Guy Rouillier <guyr-ml1@burntmail.com>
2009-03-12 19:45 ` Re: Postgresql Andreas Kretschmer <akretschmer@spamfence.net>
2009-03-12 19:56 ` Re: Postgresql Rich Shepard <rshepard@appl-ecosys.com>
2009-03-12 20:02 ` Re: Postgresql Raymond O'Donnell <rod@iol.ie>
2009-03-12 20:39 ` Re: Postgresql John R Pierce <pierce@hogranch.com>
2018-08-19 17:53 Postgresql Sonam Sharma <sonams1209@gmail.com>
2018-08-19 17:55 ` Re: Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
2018-08-19 17:56 ` Re: Postgresql Sonam Sharma <sonams1209@gmail.com>
2018-08-19 18:00 ` Re: Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
2018-08-19 18:01 ` Re: Postgresql Christophe Pettus <xof@thebuild.com>
2018-08-19 18:37 ` Re: Postgresql Chris Travers <chris.travers@gmail.com>
2018-09-25 20:16 ` Re: Postgresql pinker <pinker@onet.eu>
2023-02-07 11:02 PostgreSQL Joseph Kennedy <joseph.kennedy.486@gmail.com>
2023-02-07 11:10 ` Re: PostgreSQL Thomas Kellerer <shammat@gmx.net>
2023-02-07 11:15 ` Re: PostgreSQL Giovanni Biscontini <biscontini.g@es2000.it>
2023-02-07 11:36 ` Re: PostgreSQL Joseph Kennedy <joseph.kennedy.486@gmail.com>
2023-02-07 13:19 ` Re: PostgreSQL Giovanni Biscontini <biscontini.g@es2000.it>
2023-02-07 14:34 ` Re: PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at>
2023-02-07 14:46 ` Re: PostgreSQL Joseph Kennedy <joseph.kennedy.486@gmail.com>
2023-02-08 00:35 ` Re: PostgreSQL Stephen Frost <sfrost@snowman.net>
2023-02-09 08:54 ` Re: PostgreSQL Joseph Kennedy <joseph.kennedy.486@gmail.com>
2023-02-09 15:42 ` Re: PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at>
2023-04-02 21:21 ` Re: PostgreSQL Joseph Kennedy <joseph.kennedy.486@gmail.com>
2023-04-03 09:45 ` Re: PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at>
2023-02-07 21:42 ` Re: PostgreSQL Peter J. Holzer <hjp-pgsql@hjp.at>
2023-02-07 23:42 ` Re: PostgreSQL Brad White <b55white@gmail.com>
2023-02-08 00:11 ` Re: PostgreSQL Brad White <b55white@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox