Re: [HACKERS] SAPDB Open Souce
> I downloaded it. The directories are two characters in length, the > files are numbers, and it is a mixture of C++, Python, and Pascal. Need > I say more. :-) 1.) What is wrong with a mixture of C++, Python and Pascal? Nothing IMHO. 2.) The directory structure is probably the consequence of the development tools (produced automatically). Such a structure can have advantages, too. 3.) I left Germany 6 years ago. I don't know what happened in the meantime, but at that time (and the past 10 years before that) virtually any major business and the majority of large hospitals were running on SAP. AFAIK, similar in other european countries. Complaints about the horrendous price structure (par with Oracle) - yes. Complaints about crappy user interfaces - yes. Complaints about arrogant support team - yes. But *no* complaints regarding data integrity, robustness, and almost no complaints regarding performance. Therefore, I think it should not be disregarded too quickly. There is certainly something to learn from it by studying it; that would be probably more productive than using the same time just thinking about own design. (Maybe start looking at their developer manuals, which are *really* helpful if you want to develop something with SAP). I can't help it (as much as I admire Postgres, and as much as I like using it), but I always perceive a certain air of arrogance blowing from this list - a feeling I don't get from other open source projects. I might be wrong here. Regards, Horst ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Re: SAP-DB
On Sat, 28 Apr 2001, Don Baccus wrote: > I humbly suggest you don't write them off quite so quickly. > > SAP is, after all, a very successful company. So is Microsoft. I got the between the lines part of Bruce's post and agree with him. -- | Matthew N. Dodd | '78 Datsun 280Z | '75 Volvo 164E | FreeBSD/NetBSD | | [EMAIL PROTECTED] | 2 x '84 Volvo 245DL| ix86,sparc,pmax | | http://www.jurai.net/~winter | For Great Justice! | ISO8802.5 4ever | ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Building Fault Tolerant/Failover PGSQL Systems
Hi, I'm new to postgresql...but so far i love it...after working with companies that have spent millions of dollars on the big "O" i must say pgsql is a breath of fresh air...nice work to all who contributed. I'm looking at building a fault tolerant/failover database [hot standby] system using pgsql. I have setup and tested out DRBD and it works pretty well...althoug no work seams to have been done on it for a while. I also just found out about eRserver but have not tried it out yet. Does anyone have suggestions/recommendations for a good system that can be used for a high volume commercially available application. Thanks! Shawn _ Get your FREE download of MSN Explorer at http://explorer.msn.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] SAP-DB
Hi guys, > > I've used the open source SAPDB and the performance is pretty damned > impressive. However, 'open source' in application to it is somewhat > deceptive, since you have to make it with SAP's proprietary build > tools/environment. > > In my opinion, however, it would be worth closely auditing SAP DB to see > what postgres can learn. I downloaded it. The directories are two characters in length, the files are numbers, and it is a mixture of C++, Python, and Pascal. Need I say more. :-) I swore I'd never post to the hackers list again, but this is an amazing statement by Bruce. Boy, the robustness of the software is determined by the number of characters in the directory name? By the languages used? Have you considered that the development tools may be abstracting out the directory names in their development environment? Someone else dissed this release because you need their development tools. Well, guess what big boys, the development tools are being released open source, too. And SAP has a history of giving you sources (not fiche or whatever) of their licensed technology so this is a fairly easy step for them. Not by the fact that SAP is a monster company, with a monster customer base, with a DB engine hardly used over here but actually quite popular in Germany? Quite popular in exactly the kind of enterprise environments that PG has yet to crack and, if you dismiss this offering with silly hand-waving, may never crack? Have you ever heard of Adabas? If you don't believe that SAP and SAP-DB are real, go talk to your fellow Great Bridge employee Jan Wieck. OK, I'll unsubscribe now ... I'm still a fan of PG, but not stupid enough to dismiss a robust, industrial-strength RDMBS system based on naive and uneducated criticism. PG has a lot to offer, and the upscale is still amazingly positive judging by the pace of development over the past two years. This is hardly a basis for hand-waving SAP DB into MySQL-land, however. I like PG, I will continue to personally use PG, and I will support SAP DB along with Oracle and PG with OpenACS 4.x. And I would expect most of my clients using that toolkit to use Oracle, with SAP DB coming in second, and PG third ... I'm not trying to demotivate or discourage the PG crowd. However, when you're in a competitive battle the best prescription for getting your bell run is to taunt and tease competitors who actually are in better shape than you. And ... SAP DB is, in many ways important to the enterprise organization. They may have an inferior page-locking concurrency scheme, I need to check on this, but in many enterprise-level commercial environments this isn't such a big deal. Since your (Bruce's) hopes for a wealthy future depends on GB IPO'ing which will only come with significant penetration of the enterprise commercial environment, I humbly suggest you don't write them off quite so quickly. SAP is, after all, a very successful company. - Don Baccus, Portland OR <[EMAIL PROTECTED]> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Service and other goodies at http://donb.photo.net.
Re: [HACKERS] SAPDB Open Souce
> Hi guys, > > I've used the open source SAPDB and the performance is pretty damned > impressive. However, 'open source' in application to it is somewhat > deceptive, since you have to make it with SAP's proprietary build > tools/environment. > > In my opinion, however, it would be worth closely auditing SAP DB to see > what postgres can learn. I downloaded it. The directories are two characters in length, the files are numbers, and it is a mixture of C++, Python, and Pascal. Need I say more. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] SAPDB Open Souce
Hi guys, I've used the open source SAPDB and the performance is pretty damned impressive. However, 'open source' in application to it is somewhat deceptive, since you have to make it with SAP's proprietary build tools/environment. In my opinion, however, it would be worth closely auditing SAP DB to see what postgres can learn. Gavin On Sat, 28 Apr 2001, Matthew wrote: > Slashdot just announced that SAP has released the souce for SAP DB under > GPL. Not sure what this mean, or what people think, but I thought the > hackers list might want to know. > > http://slashdot.org/developers/01/04/28/016220.shtml > > http://www.sap.com/solutions/technology/sapdb/develop/dev_sources.htm > > Matt > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] Re: Struggling with c functions
You actually almost have it right.
You are passing VARDATA(user) to crypt, this is wrong.
You must do something like this:
int ulen = VARSIZE(user)-VARHDRSZ;
char utmp[ulen+]; // This works in newer GCC, cool.
memcpy(utmp,VARDATA(user), len);
utmp[ulen]=0;
crypted=crypt(utmp,salt);
Strings are not gurenteed to be NULL teminated.
Olivier PRENANT wrote:
>
> Hi all,
>
> I'm rewriting my OLD crypt (Thanks to Henrique) C_fonction to version 0
> forms :
>
> I have this C file compiled OK to a shared library:
>
> /*
> *
> * Henrique Pantarotto ([EMAIL PROTECTED])
> * Funcao para encriptar senhas (Function to encrypt passwords)
> * September 1999
> *
> * PS: Note that all crypted passwords are created with salt "HP" (my name
> * initials..) You can change that, or if you know C, you can do in a way
> * that it will pick two random characters (the way it should really be).
> *
> */
>
> #include
> #include
>
> #include
>
> text *post_crypt(text *user)
> {
> text *password;
> char * crypt();
> long now=time((long *) 0);
> int len;
> char salt[7]="PY", *crypted;
> /*strcpy(salt,l64a(now));
>salt[3]='\0'; */
> crypted=crypt(VARDATA(user),salt);
> len=strlen(crypted);
> password= palloc((int32) 13 + VARHDRSZ);
> VARATT_SIZEP(password)= (int32) VARHDRSZ + 13;
> memcpy(VARDATA(password),crypted,len);
> return password;
> }
>
> text *sql_crypt(text *user,text *salt)
> {
> text *password;
> char * crypt(), *crypted;
> int len;
> char s[3];
> strncpy(s,VARDATA(salt),2);
> s[2]='\0';
> crypted=crypt(VARDATA(user),s);
> len=strlen(crypted);
> password=palloc((int32) 13 + VARHDRSZ);
> VARATT_SIZEP(password)=(int32) 13 + VARHDRSZ;
> memcpy(VARDATA(password),crypted,len);
> return password;
> }
>
> /*
> Compile using something like this:
>
> gcc -I/home/postgres/postgresql-6.5.1/src/include
>-I/home/postgres/postgresql-6.5.1/src/backend -O2 -Wall -Wmissing-prototypes -fpic
>-I/home/postgres/postgresql-6.5.1/src/include -c -o encrypt.o encrypt.c
> gcc -shared -o encrypt.so encrypt.o
>
> And last, you create the trigger in PostgreSQL using this:
>
> create function encrypt(text)
> returns text as '/usr/local/pgsql/lib/encrypt.so' language 'c';
>
> If everything is okay, you'll probably have: select encrypt('secret') working
> and showing:
>
> encrypt
>
> HPK1Jt2NX21G.
> (1 row)
> */
>
> I have defined to SQL function:
>
> CREATE FUNCTION post_crypt(text) RETURNS text AS '/encrypt.so'
> CREATE FUNCTION sql_cypt(text,text) RETURNS text AS '/encrypt.so';
>
> WHY on earth does
>
> SELECT post_crypt('test'),sql_crypt('test','PY')
> NOT GIVE the same result???
>
> Please help,
>
> This is most urgent (My customer can't use this function anymore); it
> worked OK with 7.0.3!!
>
> Regards,
> --
> Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
> Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
> 31190 AUTERIVE +33-6-07-63-80-64 (GSM)
> FRANCE Email: [EMAIL PROTECTED]
> --
> Make your life a dream, make your dream a reality. (St Exupery)
>
> ---(end of broadcast)---
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
--
I'm not offering myself as an example; every life evolves by its own laws.
http://www.mohawksoft.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [PATCHES] Re: [HACKERS] Support for %TYPE in CREATE FUNCTION
> > Using %TYPE makes it easier to write a function which is independent > > of the definition of a table. That is, minor changes to the types > > used in the table may not require changes to the function. > > Wow! This would be _very_ useful! It's something I wish PostgreSQL > had and I miss it everytime I write functions and remember PL/SQL. > > Thanks a lot Ian, I hope this one makes it in (hopefully for 7.1.1) Sorry, only in 7.2. No new features in minor releases unless they are very safe. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Re: v7.1.1 branched and released on Tuesday ...
Thomas Lockhart writes: > Nothing serious, but I would like to apply a patch to allow IDENT > strings (e.g. 'hour') to be accepted by the SQL92 EXTRACT() function. We > accept those for date_part(), which is what EXTRACT() is translated to > by the parser, and it seems to be a reasonable to the standard. But why does that need to go into 7.1.1? -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] PQftype()
Where do get a listing of what PQftype() can return to me? (that is what type the field/col has, need a list of Oid's i believe) Magnus -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Programmer/Networker [|] Magnus Naeslund PGP Key: http://www.genline.nu/mag_pgp.txt -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Struggling with c functions
Hi all,
I'm rewriting my OLD crypt (Thanks to Henrique) C_fonction to version 0
forms :
I have this C file compiled OK to a shared library:
/*
*
* Henrique Pantarotto ([EMAIL PROTECTED])
* Funcao para encriptar senhas (Function to encrypt passwords)
* September 1999
*
* PS: Note that all crypted passwords are created with salt "HP" (my name
* initials..) You can change that, or if you know C, you can do in a way
* that it will pick two random characters (the way it should really be).
*
*/
#include
#include
#include
text *post_crypt(text *user)
{
text *password;
char * crypt();
long now=time((long *) 0);
int len;
char salt[7]="PY", *crypted;
/*strcpy(salt,l64a(now));
salt[3]='\0'; */
crypted=crypt(VARDATA(user),salt);
len=strlen(crypted);
password= palloc((int32) 13 + VARHDRSZ);
VARATT_SIZEP(password)= (int32) VARHDRSZ + 13;
memcpy(VARDATA(password),crypted,len);
return password;
}
text *sql_crypt(text *user,text *salt)
{
text *password;
char * crypt(), *crypted;
int len;
char s[3];
strncpy(s,VARDATA(salt),2);
s[2]='\0';
crypted=crypt(VARDATA(user),s);
len=strlen(crypted);
password=palloc((int32) 13 + VARHDRSZ);
VARATT_SIZEP(password)=(int32) 13 + VARHDRSZ;
memcpy(VARDATA(password),crypted,len);
return password;
}
/*
Compile using something like this:
gcc -I/home/postgres/postgresql-6.5.1/src/include
-I/home/postgres/postgresql-6.5.1/src/backend -O2 -Wall -Wmissing-prototypes -fpic
-I/home/postgres/postgresql-6.5.1/src/include -c -o encrypt.o encrypt.c
gcc -shared -o encrypt.so encrypt.o
And last, you create the trigger in PostgreSQL using this:
create function encrypt(text)
returns text as '/usr/local/pgsql/lib/encrypt.so' language 'c';
If everything is okay, you'll probably have: select encrypt('secret') working
and showing:
encrypt
HPK1Jt2NX21G.
(1 row)
*/
I have defined to SQL function:
CREATE FUNCTION post_crypt(text) RETURNS text AS '/encrypt.so'
CREATE FUNCTION sql_cypt(text,text) RETURNS text AS '/encrypt.so';
WHY on earth does
SELECT post_crypt('test'),sql_crypt('test','PY')
NOT GIVE the same result???
Please help,
This is most urgent (My customer can't use this function anymore); it
worked OK with 7.0.3!!
Regards,
--
Olivier PRENANT Tel:+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: [EMAIL PROTECTED]
--
Make your life a dream, make your dream a reality. (St Exupery)
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
[HACKERS] after changing login password (local), CPU always 100% !!
1) I login as administrator (local) at our SQL 2000 server. 2) change password for administrator 3) reboot server 4) login in as administrator (local) with new password 5) receive message "SQL Agent cannot start" because "login failure" 6) change password for administrator again back to previous one and reboot 7) login as administrator (local) with previous password 8) SQL Agent and server start as usual... however, when i check performance monitor, CPU always 100% !!! performance is siginificantly degraded !! 9) the only solution is to stop both SQL Server and SQL Agent and start both of them one by one manually. Bill !! why you do this to me Anyone can help? -= Posted via Newsfeeds.Com, Uncensored Usenet News =- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -== Over 80,000 Newsgroups - 16 Different Servers! =- ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Re: WAL feature
What about incremental backup ? "Bruce Momjian" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > WAL was a difficult feature to add to 7.1. Currently, it is only used > as a performance benefit, but I expect it will be used in the future to > add new features like: > > Advanced Replication > Point-in-time recovery > Row reuse without vacuum > > -- > Bruce Momjian| http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] While we're on the subject of searches...
Over the past few months there've been a number of requests for an interactive type documentation setup like the folks at php.net have. Great to add to the documentation, but I hope the PostgreSQL project doesn't take it so far as to make the primary documentation interactive. A well-thought out, coherent document is _much_ more useful than the skads of random tips that characterize some other projects. The current document is very well-written (though perhaps incomplete). I would hate to see that decline in quality. Cheers, Brook ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] RE:PAM Authentication for PostgreSQL...
Dominic, I like your idea. One of the benefits SQLServer 2000 is that I can assign a role in the database to a NT group. At that point, all I have to do is add a user to the group to be able to access that database. Would you solution include this scenario? This lets me assign all the resources needed for an application to a group. Then to let people access the application, all I have to do is add them to a group in one spot. Ryan. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] SAPDB Open Souce
Slashdot just announced that SAP has released the souce for SAP DB under GPL. Not sure what this mean, or what people think, but I thought the hackers list might want to know. http://slashdot.org/developers/01/04/28/016220.shtml http://www.sap.com/solutions/technology/sapdb/develop/dev_sources.htm Matt ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Support for %TYPE in CREATE FUNCTION
On Fri, Apr 27, 2001 at 08:45:25PM -0700, Ian Lance Taylor wrote: > This patch adds support for %TYPE in CREATE FUNCTION argument and > return types. > > %TYPE is already supported by PL/pgSQL when declaring variables. > However, that does not help with the argument and return types in > CREATE FUNCTION. > > Using %TYPE makes it easier to write a function which is independent > of the definition of a table. That is, minor changes to the types > used in the table may not require changes to the function. Wow! This would be _very_ useful! It's something I wish PostgreSQL had and I miss it everytime I write functions and remember PL/SQL. Thanks a lot Ian, I hope this one makes it in (hopefully for 7.1.1) -Roberto -- +| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer -°*'. (Explosive Tagline) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] WAL performance with wal_sync_method = open_sync
Hi, I'm playing with wal parameters and found that wal_sync_method = open_sync enormously enhance the performance on my machine. Without it (using default fsync) I got only 90 tps at the best using pgbench (-s 2). However if I set wal_sync_method = open_sync, I get ~200 tps. I have checked PostgreSQL uses O_SYNC flag when it opens WAL log files using strace. Can anybody tell me why? I am afraid this is just a dream:-) Linux kernel 2.2.17. -- Tatsuo Ishii ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
