[GENERAL] Re: Re: grant privileges to a database [URGENT]
El Mi 31 Ene 2001 21:32, Mike Miller escribi: MySQL has this feature. I run a multi-user system and require shared MySQL And PostgreSQL dbs. I have mysql fine. Users have their DBs and can only access their DBs... but theres no real way to do this in Postgres. I can restrict tables, but I can still create tables in other poeples DBs. Maybe only allowed to acess DBs you create or are assigned permission to This is what I'm talking about (sort of) and I find it a handy thing that informix has since at least 1995. Lets say I have a database server and I create databases for diferent groups of people to populate. Thtas what grant dba would be usefull for. Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [GENERAL] Re: grant privileges to a database
El Mi 31 Ene 2001 15:53, Michael Fork escribi: This is the closest thing to what you want: GRANT ALL ON table TO user; (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm) Yes, I'm aware of that. That's why I'm asking for an opinion of the developers on this issue. I think it would be a nice feature, so that the postgres user creates the database and gives all kind of permissions on that database to another user, which doesn't have to be able to create databases. Any comments? -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[GENERAL] Re: grant privileges to a database
El Mar 30 Ene 2001 10:08, Martin A. Marques escribi: Is there a way to grant a user with all privileges on a database? Something like Informixs GRANT dba? OK, I see that no one responded (except one person how made a personal responce), so I'll add a bit to it. I seem to be aware that Postgres doesn't have a function to grant total access to a database, so is it posible to have this added to the todo list for further versions? Or is it posible to build a user-function that will let me do this: postgres@ultra3:~ psql horde horde=# CREATE DATABASE test; CREATE DATABASE horde=# GRANT dba TO martin; -- here is the grant issue. GRANT horde=# \c test martin; You are now connected to database test as user martin. test=# CREATE TABLE (aid SERIAL, texto TEXT); CREATE TABLE test=# Saludos... ;-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Re: Talking about Solaris 7
El Lun 29 Ene 2001 07:57, Alexander Klimov escribi: Hi. I had the same problem and sent bug report to [EMAIL PROTECTED] some time ago (20 Sep 2000), so, hopefully, they will fix it eventualy. There is a workaround for it. The comment in ssl/include/openssl/des.h said: `You should not use this function except to implement 'modes' of DES.', so you can just comment out declaration of des_encrypt (line 150) without any problem. Now, why are the definitions so different? /usr/include/crypt.h:23 (I guess this is Solaris crypt header) extern void des_encrypt(char *, int); and /usr/local/ssl/include/openssl/des.h:150 (this is from openssl) void des_encrypt(DES_LONG *data,des_key_schedule ks, int enc); I may be wrong, but why are the two functions decrared with different arguments? -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Re: PHP - Postgres large object functions
El Mi 24 Ene 2001 17:56, Ned Lilly escribi: Adam, FYI, according to Rasmus Lerdorf, your patches have been committed. From the changelog: 2001-01-18 Derick Rethans [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * ext/pgsql/pgsql.c ext/pgsql/php_pgsql.h: - Added the pg_lolseek function, which allows for arbitrary seeking within a large object, and the pg_lotell call, which can be used to find the current file offset for a large object (Submitted by: Adam Haberlach [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]). - Added the pg_lolseek and pg_lotell functions I've had headaches trying to understand how PHP works with postgres large objects. Is there some kind of "understandable" docs on this behave? Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Talking about Solaris 7
I have a problem with the compilation of Postgres on Solaris with ssl support. The error I get is this when executing make: gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c nodeTidscan.c -o nodeTidscan.ogcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c spi.c -o spi.o /usr/ccs/bin/ld -r -o SUBSYS.o execAmi.o execFlatten.o execJunk.o execMain.o execProcnode.o execQual.o execScan.o execTuples.o execUtils.o functions.o nodeAppend.o nodeAgg.o nodeHash.o nodeHashjoin.o nodeIndexscan.o nodeMaterial.o nodeMergejoin.o nodeNestloop.o nodeResult.o nodeSeqscan.o nodeSetOp.o nodeSort.o nodeUnique.o nodeLimit.o nodeGroup.o nodeSubplan.o nodeSubqueryscan.o nodeTidscan.o spi.o make[3]: Leaving directory `/space/pruebas/postgresql-7.1beta1/src/backend/executor' /usr/local/bin/make -C lib all make[3]: Entering directory `/space/pruebas/postgresql-7.1beta1/src/backend/lib' gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c bit.c -o bit.o gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c hasht.c -o hasht.o gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c lispsort.c -o lispsort.o gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c stringinfo.c -o stringinfo.o gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c dllist.c -o dllist.o /usr/ccs/bin/ld -r -o SUBSYS.o bit.o hasht.o lispsort.o stringinfo.o dllist.o make[3]: Leaving directory `/space/pruebas/postgresql-7.1beta1/src/backend/lib' /usr/local/bin/make -C libpq all make[3]: Entering directory `/space/pruebas/postgresql-7.1beta1/src/backend/libpq' gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c be-fsstubs.c -o be-fsstubs.o gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c auth.c -o auth.o gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -I/usr/local/include -I/usr/local/ssl//include -I../../../src/include -c crypt.c -o crypt.o In file included from crypt.c:27: /usr/include/crypt.h:23: conflicting types for `des_encrypt' /usr/local/ssl/include/openssl/des.h:150: previous declaration of `des_encrypt' make[3]: *** [crypt.o] Error 1 make[3]: Leaving directory `/space/pruebas/postgresql-7.1beta1/src/backend/libpq' make[2]: *** [libpq-recursive] Error 2 make[2]: Leaving directory `/space/pruebas/postgresql-7.1beta1/src/backend' make[1]: *** [all] Error 2 make[1]: Leaving directory `/space/pruebas/postgresql-7.1beta1/src' make: *** [all] Error 2 *** Error code 2 make: Fatal error: Command failed for target `all' Any extra code you may want, just ask. -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] Re: [GENERAL] re-instalation
El Sb 20 Ene 2001 18:43, Peter Eisentraut escribi: Martin A. Marques writes: Any ideas why those pg* tables are there? Those are system tables created and used by pgAccess. They never apeared before. You probably never ran pgaccess before. No, I used to run pgaccess daily. And by the way, I see all the system tables when looking at any database with pgaccess (another thing that didn't happen before). Go to the menu Databases - Preferences and check off "View system tables". Great Peter!! That did it! (I'm clueless :-P ) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] compiling 7.1-beta1
El Jue 18 Ene 2001 15:15, Tom Lane escribi: The other question is if I have to do something special (dump and restore) when upgrading from 7.1-beta1 to 7.1-final (or any of the other betas)? You will need an initdb to go from beta1 to beta3. Sorry about that; we try to avoid forced initdb after beta cycle starts, but sometimes it's not possible. You might want to skip testing beta1 and just start with beta3, or even a current nightly snapshot. Well, my problem was that a downgrade had to be made to the only Solaris8 SPARC back to Solaris7, and postgres broke. So I recompiled it, in a new directory, and copied the data directory to the new postgres instaltion directory, but when I connect with pgaccess to and db, I see the postgres tables (like pg_aggregate, pg_group, pg_scripts, pg_trigger, etc). Did I do something wrong? Any way to fix it? -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[GENERAL] re-instalation
I had to re-compile and re-install postgresql-7.1-beta1. I changed the directory where it was installed from /usr/local/pgsql to /dbs/postgres/. After re-installing I copied the data/ directory that was under the old instalation to where I have the new instalation. After a bit of work I got it to work, but when I conect to any of the databases I see tables that don't belong there: postgres@ultra31:~ psql horde Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit horde=# \dt List of relations Name | Type | Owner -+---+-- active_sessions | table | postgres imp_addr| table | postgres imp_pref| table | postgres pga_forms | table | postgres pga_queries | table | postgres pga_reports | table | postgres pga_schema | table | postgres pga_scripts | table | postgres (8 rows) Any ideas why those pg* tables are there? TIA. -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [GENERAL] re-instalation
El Vie 19 Ene 2001 17:36, Len Morgan escribi: pga_forms | table | postgres pga_queries | table | postgres pga_reports | table | postgres pga_schema | table | postgres pga_scripts | table | postgres (8 rows) Any ideas why those pg* tables are there? You have apparently used pg_access at least once. It creates these tables for itself. Yes, but they shouldn't be visable (am I wrong?), just like I shouldn't be seeing with pgaccess, and conecting to the same db, tables like: pg_proc pg_inherits pg_type, etc. I didn't have this problems before doing this re-instalation. TIA -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] compiling 7.1-beta1
I'm compiling beta 1 of 7.1 and I have a par of questions. First I see things like this in the compilation output: gcc -g -Wall -Wmissing-prototypes -Wmissing-declarations -Wno-error -I/usr/local/ssl//include -I../../../src/include -c analyze.c -o analyze.o analyze.c: In function `transformInsertStmt': analyze.c:425: warning: unused variable `resnode' I know it's nothing serious, but. Is it because it's in beta, and some trashed code hasn't been taken off? The other question is if I have to do something special (dump and restore) when upgrading from 7.1-beta1 to 7.1-final (or any of the other betas)? Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Re: still no log
El Mi 10 Ene 2001 20:55, Alfonso Peniche escribi: Existe un archivo llamado postmaster.init en el directorio de postgres, en ese directorio le especificas si quieres que use o no los logs. Ya revisaste ese archivo? No existe tal archivo, pero ya lo sulocione. Gracias de todas formas. ;-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Re: psql -l bug
On Wed, 10 Jan 2001, Olivier PRENANT wrote: Hi, I just recompiled 7.1 beta from current CVS today. I pg_dump'ed my 7.02 db's and reloaded it on 7.1 with no probs apart that psql -l shows 2 template0 and template1... Template0 and template1 belong to user postgres and to an other who has no priviledges and no db!!! What makes me think it's a psql bug is that select * from pg_databases show 1 template0 and 1 template1. For what it's worth, it on unixware 711. For more info (don't think it's a bug) I see two templates db too. BTW, when is the release due for? I'm VERY impatient. This is the best I've seen. I'm looking forword to seeing the release of 7.1. System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] still no log
Sorry for the insistence, but after looking and looking again, I can't find out why the postgres logs are empty. The postgres database is up and working great, but nothing is getting logged. I'm on a RedHat Linux (6.0 with lot of upgrades) postgres 7.0.3 from rpm (downoaded from the postgres ftp server) Any ideas? -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Re: still no log
El Mi 10 Ene 2001 21:07, escribiste: "Martin A. Marques" wrote: Sorry for the insistence, but after looking and looking again, I can't find out why the postgres logs are empty. The postgres database is up and working great, but nothing is getting logged. I'm on a RedHat Linux (6.0 with lot of upgrades) postgres 7.0.3 from rpm (downoaded from the postgres ftp server) Any ideas? If postmaster is started with -S, nothing gets logged. Is that your problem? Well, I'm not sure. I can't recall checking that in the startup script, but I think it's not there. Any way, why would the instalation make the entries in the logroutate config files and then have a startup script that won't do logging? I'm using the normal startup script in /etc/rc.d/init.d/. Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] How to print explain using PHP
I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with PHP, to the postgres backend the output goes to the error_log file of apache and I don't know how to redirect that output to the browser. Does anyone know how I can do this? Saludos... ;-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[GENERAL] Re: How to print explain using PHP
El Mar 09 Ene 2001 16:30, Karel Zak escribi: On Tue, 9 Jan 2001, Martin A. Marques wrote: I'm working with PHP and Postgres, and if I try to do an EXPLAIN query, with PHP, to the postgres backend the output goes to the error_log file of apache and I don't know how to redirect that output to the browser. Good point, before some time somebody (Bruce?) ask if anything is needful add to PostgreSQL extension in PHP. You found that... PHP not support libpq's routine: PQnoticeProcessor PQsetNoticeProcessor( PGconn *conn, PQnoticeProcessor proc, void *arg); I think it would be of great help for web programers that use postgres. Any way, I'm doing some messy things to get what I want, but it is a very needfull extension. Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martn Marqus email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] problems with query
Hi, I have this table on postgres-7.0.3
CREATE TABLE ciudad (
id_ciudadSERIAL,
ciudad VARCHAR(60)
);
GRANT ALL ON ciudad TO martin;
CREATE INDEX ciudad_idx ON ciudad (ciudad);
And I try to insert a value using this query:
INSERT INTO ciudad (ciudad) VALUES ("Villa Guillermina")
getting as responce the message:
ERROR: Attribute 'Villa Guillermina' not found.
The field ciudad is of type varchar(60), so I don't get why it gives me this
message.
Any ideas?
--
System Administration: It's a dirty job,
but someone told I had to do it.
-
Martín Marqués email: [EMAIL PROTECTED]
Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-
Re: [HACKERS] Why vacuum?
El Mié 13 Dic 2000 22:24, xuyifeng escribió: I have this nasty problem too, in early time, I don't know the problem, but we used it for a while, than we found our table growing too fast without insert any record( we use update), this behaviour most like M$ MSACCESS database I had used a long time ago which don't reuse deleted record space and full fill your hard disk after several hours, the nasty vaccum block any other users to operate on table, this is a big problem for a large table, because it will block tooo long to let other user to run query. we have a project affected by this problem, and sadly we decide to use closure source database - SYBASE on linux, we havn't any other selections. :( note that SYBASE and Informix both have 'update statistics' command, but they run it fast in seconds, not block any other user, this is pretty. ya, what's good technology! I have to say that 'update statistics' does not take a few seconds if the databases have grownto be a bit large. At least thats what I have seen. Saludos... :-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] docs
Hi, Where can I find documentation on WAL, TOAST and how to configure the pg_hda.conf file? Saludos... ;-) -- System Administration: It's a dirty job, but someone told I had to do it. - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] No postgres on Solaris
Hi, I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and was about to upgrade to 7.1-test, and after following carefully the docs, I get this: postgres@ultra31:~ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: No space left on device This error does *not* mean that you have run out of disk space. It occurs either because system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Look into the PostgreSQL documentation for details. postgres@ultra31:~ I looked at the FAQ_Solaris, but found nothing on this case. I remember making changes to the kernel parameters when I fist installed postgres, but can't remember where I found that info. Any clues? -- System Administration: It's a dirty job, but someone told I had to do it. - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] v7.1 beta 1 ...packaged, finally ...
On Thursday 07 December 2000 16:48, The Hermit Hacker wrote: Okay, since I haven't gotten word back on where to find the docs for v7.1, it still contains those for v7.0, but I just put up beta1 tarballs in the /pub/dev directory ... can someone take a look at these before we announce them to make sure they look okay? I'm in the process of downloading. What would be the diff between the beta1 and the snapshot? Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] v7.1 beta 1 ...packaged, finally ...
On Thursday 07 December 2000 18:35, Peter Eisentraut wrote: Ideally (IMHO) we'd build the documentation right in place when making the distribution tarball, i.e., broken docs, no release. I'm not sure how to usefully extrapolate that to the snapshot builds, though. Another thing we should think about is to not tar.gz the documentation files. That way we could create useful incremental diffs between releases later on. Any comments here? If you dont't tar.gz the docs, what should the downladable format be? CVS? I think CVS would be great. -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] beta testing version
On Sunday 03 December 2000 04:00, Vadim Mikheev wrote: There is risk here. It isn't so much in the fact that PostgreSQL, Inc is doing a couple of modest closed-source things with the code. After all, the PG community has long acknowleged that the BSD license would allow others to co-op the code and commercialize it with no obligations. It is rather sad to see PG, Inc. take the first step in this direction. How long until the entire code base gets co-opted? I totaly missed your point here. How closing source of ERserver is related to closing code of PostgreSQL DB server? Let me clear things: 1. ERserver isn't based on WAL. It will work with any version = 6.5 2. WAL was partially sponsored by my employer, Sectorbase.com, not by PG, Inc. Has somebody thought about putting PG in the GPL licence instead of the BSD? PG inc would still be able to do there money giving support (just like IBM, HP and Compaq are doing there share with Linux), without been able to close the code. Only a thought... Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] beta testing version
On Sunday 03 December 2000 12:41, mlw wrote: Thomas Lockhart wrote: As soon as you find a business model which does not require income, let me know. The .com'ers are trying it at the moment, and there seems to be a few flaws... ;) While I have not contributed anything to Postgres yet, I have contributed to other environments. The prospect that I could create a piece of code, spend weeks/years of my own time on something and some entity can come along, take what I've written and create a product which is better for it, and then not share back is offensive. Under GPL it is illegal. (Postgres should try to move to GPL) With you on the last statemente. I am working on a full-text search engine for Postgres. A really fast one, something better than anything else out there. It combines the power and scalability of a web search engine, with the data-mining capabilities of SQL. If you want to make something GPL I would be more then interested to help you. We could use something like that over here, and I have no problem at all with releasing it as GPL code. If I write this extension to Postgres, and release it, is it right that a business can come along, add a few things here and there and introduce a new closed source product on what I have written? That is certainly not what I intend. My intention was to honor the people before me for providing the rich environment which is Postgres. I have made real money using Postgres in a work environment. The time I would give back more than covers MSSQL/Oracle licenses. I'm not sure, but you could introduce a peice of GPL code in the BSD code, but the result would have to be GPL. Hoping to hear from you, -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] beta testing version
On Sunday 03 December 2000 21:49, The Hermit Hacker wrote: I've been trying to follow this thread, and seem to have missed where someone arrived at the conclusion that we were proprietarizing(word?) this I have missed that part as well. ... we do apologize that it didn't get out mid-October, but it is/was purely a scheduale slip ... I would never say something about schedules of OSS. Let it be in BSD or GPL license. Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] beta testing version
On Tuesday 05 December 2000 18:03, The Hermit Hacker wrote: Has somebody thought about putting PG in the GPL licence instead of the BSD? its been brought up and rejected continuously ... in some of our opinions, GPL is more harmful then helpful ... as has been said before many times, and I'm sure will continue to be said "changing the license to GPL is a non-discussable issue" ... It's pretty clear to me, and I respect the decision (I really do). -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] Crash during WAL recovery?
On Wednesday 22 November 2000 02:36, Don Baccus wrote: More generally, a lot of the PG documentation could use the attention of a professional copy editor --- and I'm sad to say that the parts contributed by native English speakers aren't necessarily any cleaner than the parts contributed by those who are not. If you have the time and energy to submit corrections, please fall to! This is very much true. PG needs some good documentation volunteers. I'm not denigrating the current efforts, because PG documention's pretty good all things considered. But some volunteers devoted to improving the docs could accomplish a lot. It would be a pleasure to help with the spanish docs, if any help is needed. Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] WAL and offline backups
One question: will Postgres 7.1 be able to do offline backups? -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL
On Lun 13 Nov 2000 13:22, Robert D. Nelson wrote: Still...Regardless of what database they're running, either their abstraction layer is shit or their queries really need optimized. Is that perhaps why, even at 5 clients, the page views he shows never went significantly above 10/sec? In the article it was said that the querys were unoptimized to get the best out of the database. Tim said that with some changes to the querys they could have gotten much better results. Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] Postgres article
Did someone read bout this? http://www.angelfire.com/nv/aldev/pgsql/GreatBridge.html Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] problems with configure
On Mié 08 Nov 2000 19:34, Tom Lane wrote: Well, maybe. But is it worth the trouble? Hard to believe anyone else did the same thing. If socklen_t exists, it's presumably the right thing to use, so if we just hardwire "void - socklen_t", I think it'd be OK. If we're wrong, we'll hear about it... Well, I would like to know how this is going to evolve. I will try to download an update with cvsup in a few hours. Hope theres something new. Else, please tell me what would be the best solution (even for the moment). Thanks -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] problems with configure
On Mié 08 Nov 2000 18:01, Tom Lane wrote: Well, that tells the tale all right: the critical lines are typedef uint32_tsocklen_t; typedef void*Psocklen_t; extern int accept(int, struct sockaddr *, Psocklen_t); What brainless idiot decided it would be a good idea to declare accept's last argument as void*, do you suppose? (At least you report that Solaris 8 no longer has this folly, so they did get a clue eventually.) Not sure what to do about this. It will clearly not do to define ACCEPT_TYPE_ARG3 as void. Perhaps we need a special case for Solaris 7: if we detect that accept() is declared with "void *", assume that socklen_t is the thing to use. Peter, any thoughts? No. Forgot to tell my latest experience. 1) postgres 7.0.2 compiles great on Solaris 7 and Solaris 8. 2) postgres cvs (latest download) doesn't compile (same error on both) on Solaris 7 nor Solaris 8. So it isn't a Solaris 7 problem, but a Solaris problem. ;-) I just wish we could install linux on one of these SPARC to have something good running. ;-) Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] still with problems to run configure
OK, it's me again with news on how I'm doing (bad) with the compilation of PostgreSQL 7.1 alpha (I think I'll call that way the cvsup download). I still can't finish the execution of the configure script (still don't know why), and I could compile 7.0.2 perfectly on the same SPARC. What could be wrong? I'm puzzled. 8- -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] problems with configure
On Lun 06 Nov 2000 18:25, Peter Eisentraut wrote:
Martin A. Marques writes:
Is there any kind of info you would need that I could provide? If you
want I can send the config.log, output of the configure execution, etc.
Even the socket.h and the types.h.
BTW, I didn't find diffs between Solaris 7 .h files and Solaris 8
headers.
Try one of the attached patches, first patch1, then patch2, preferrably
each one separately.
Didn't work. :-(
This was the output:
martin@ultra208 ~/basura/post-final $ patch -p0 patch1 Looks like a
context diff to me... Hunk #1 failed at line 5483. 1 out of 1 hunks failed:
saving rejects to configure.rej done
configure.rej contains this:
martin@ultra208 ~/basura/post-final $ less configure.rej
***
*** 5483,5489
#ifdef HAVE_SYS_SOCKET_H
#include sys/socket.h
#endif
! extern accept ($ac_cv_func_accept_arg1, $ac_cv_func_accept_arg2,
$ac_cv_func_accept_arg3 *);
int main() {
; return 0; }
--- 5483,5489
#ifdef HAVE_SYS_SOCKET_H
#include sys/socket.h
#endif
! extern int accept ($ac_cv_func_accept_arg1, $ac_cv_func_accept_arg2,
$ac_cv_func_accept_arg3 *);
int main() {
; return 0; }
Tried to apply what the patch said by hand, ran the configure, but I get the
same error.
I think today afternoon I will try some new things to see where the problem
can be.
Saludos... ;-)
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-
Martín Marqués email: [EMAIL PROTECTED]
Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-
Re: [HACKERS] problems with configure
On Vie 03 Nov 2000 20:37, Peter Eisentraut wrote:
Martin A. Marques writes:
checking types of arguments for accept()... configure: error: could not
determine argument types
According to the documentation for Solaris 7 it should be 'accept(int,
struct sockaddr *, socklen_t *)', which is the same on my system, so the
Well, mine looks like:
extern int accept(int, struct sockaddr *, Psocklen_t);
problem is elsewhere. One possibility is that the earlier tests for
sys/types.h or sys/socket.h failed. Could you check what the file
config.log says?
Everything looks good. No problems with those checks.
I checked the configure on the lines that give the error and I don't
understand what It's trying to do. It has various variables with I don' t
know where they are defined. Can somebody give me a clue?
This is what I have in the configure:
#line 5479 "configure"
#include "confdefs.h"
#ifdef HAVE_SYS_TYPES_H
#include sys/types.h
#endif
#ifdef HAVE_SYS_SOCKET_H
#include sys/socket.h
#endif
extern accept ($ac_cv_func_accept_arg1, $ac_cv_func_accept_arg2,
$ac_cv_func_accept_arg3 *);
int main() {
; return 0; }
Saludos... :-)
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-
Martín Marqués email: [EMAIL PROTECTED]
Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-
Re: [HACKERS] problems with configure
On Lun 06 Nov 2000 12:06, Tom Lane wrote: "Martin A. Marques" [EMAIL PROTECTED] writes: Well, mine looks like: extern int accept(int, struct sockaddr *, Psocklen_t); This is what I have in the configure: extern accept ($ac_cv_func_accept_arg1, $ac_cv_func_accept_arg2, $ac_cv_func_accept_arg3 *); Hmm ... is it possible that his compiler distinguishes between "extern int foo(...)" and "extern foo(...)" ? Why don't we have the return type there, anyway? If it's of any help, I'm on Solaris 7, SPARC, gcc-2.95.2, latest Postgres CVS. Another question would be, why didn't I have problems of this type when I compiled PostgreSQL 7.0.2 on Solaris 8, with the same version of gcc? Thanks for the patience. -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] problems with configure
On Lun 06 Nov 2000 13:28, Tom Lane wrote: "Martin A. Marques" [EMAIL PROTECTED] writes: Hmm ... is it possible that his compiler distinguishes between "extern int foo(...)" and "extern foo(...)" ? Why don't we have the return type there, anyway? If it's of any help, I'm on Solaris 7, SPARC, gcc-2.95.2, latest Postgres CVS. Another question would be, why didn't I have problems of this type when I compiled PostgreSQL 7.0.2 on Solaris 8, with the same version of gcc? Different header files, likely. I'm starting to wonder if Solaris 7 has some header-file dependency for sys/socket.h beyond the one that the test is allowing for (sys/types.h). Is there any kind of info you would need that I could provide? If you want I can send the config.log, output of the configure execution, etc. Even the socket.h and the types.h. BTW, I didn't find diffs between Solaris 7 .h files and Solaris 8 headers. BTW, does 'Psocklen_t' equate to just 'socklen_t *', or is there something strange hidden there? I don' t have the slightest idea. -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] problems with configure
I'm trying to compile the CVS (fresh download) of postgres and I get this running the configure script: checking for tzname... yes checking for union semun... no checking for struct sockaddr_un... yes checking for int timezone... yes checking types of arguments for accept()... configure: error: could not determine argument types My configure options are these: ./configure --prefix=/usr/local/pgsql/ --cache-file=config.cache --enable-locale --enable-uniconv --with-maxbackends=128 --without-tk --with-openssl=/usr/local/ssl/ --enable-syslog and I'm running a Solaris 7 with gcc 2.95.2. Any ideas? -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] status applications
On Mié 01 Nov 2000 20:57, Martin A. Marques wrote: Seeing that nobody responded to my questions, here I go. ;-) I think one of the poor partes about postgres is the administration tools. I am not a PostgreSQL hacker (would like to be one) so I don know if there are things like user threads, locks and all those stuff to check for with some sort of administration tool. I am willing to help in the development of this tool, and I think it would be very important for the PostgreSQL community, adn for PostgreSQL as a whole. Any comments? Bruce? Tom? Vadim? Are there any status and mode applications for postgres? I mean, an application that will tell me the status of the server at the moment, and an app to start and stop postgres. Does postgres have "administration mode" like a mode to make backups on, without threads connected? Thanks!!! Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] status applications
On Jue 02 Nov 2000 15:27, you wrote: Martin A. Marques writes: Are there any status and mode applications for postgres? I mean, an application that will tell me the status of the server at the moment, and an app to start and stop postgres. pg_ctl Yes, I have just been checking on that script. Does postgres have "administration mode" like a mode to make backups on, without threads connected? You just disallow everyone to connect. How would you do something like that? Thanks. -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] status applications
Are there any status and mode applications for postgres? I mean, an application that will tell me the status of the server at the moment, and an app to start and stop postgres. Does postgres have "administration mode" like a mode to make backups on, without threads connected? Thanks!!! -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] BAR now and with 7.1
I wanna know how BAR (Backup And Restore) is done now (PostgreSQL 7.0.2) and how it will be done when PostgreSQL 7.1 comes out. What I want is a total recover of data up to the time that the database got scratched. What I mean is: Certain people write to the database all day long. Every mid-night I do a full backup (level 0). If the database gets destroyed for any reason, I would do I full restore of the last mid-night backup, but I also want all the info that was changed after the last Level 0 backup. Is this posible with PostgreSQL 7.0.2? Will it be posible with PostgreSQL 7.1? Thanks!! -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] WAL status todo
On Sat, 14 Oct 2000, Vadim Mikheev wrote: Well, hopefully WAL will be ready for alpha testing in a few days. Unfortunately at the moment I have to step side from main stream to implement new file naming, the biggest todo for integration WAL into system. I would really appreciate any help in the following issues (testing can start regardless of their statuses but they must be resolved anyway): I have downloaded the source via CVSup. Where can I find the WAL and the TOAST code? Thanks!! -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
RE: [HACKERS] backup and restore
On Thu, 12 Oct 2000, Mikheev, Vadim wrote: Could this be added? I am willing to help with the coding. This is what Version 7.1 WAL is all about. There might be some help wanted in one of the possible backup methods: 1. a pg_dumpall restore, and a subsequent restore of logs 2. a restore of a "physical backup of db files" + subsequent restore of logs I think Vadim has the 1st way in his works. No, 2nd. WAL reflects layout of tuples in data files, so I don't see how pg_dump output could be used. I'll really appreciate if someone will help with this issue ... after alpha testing will start next week. Where is this code? How can we get it? "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
Re: [HACKERS] backup and restore
On Mon, 02 Oct 2000, Hannu Krosing wrote: "Martin A. Marques" wrote: Hi, I would like to know if postgres comes with some kind of backup application? I mean something that would do database backup and restore, something like informix's ontape and logical logs. Take a look at pg_dump and pg_dumpall Well, that would only be part og what I'm looking for. The thing I like about informix is that I can make a Level 0 backup of all the data (equal to the pg_dumpall), and then leave the logical logs downloading continuosly, so that if in one moment the system breaks, I restore the Level 0 backup and then apply the logical logs, which are the small changes that have been done to the database in each transaction, administration, etc. Could this be added? I am willing to help with the coding. Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
[HACKERS] backup and restore
Hi, I would like to know if postgres comes with some kind of backup application? I mean something that would do database backup and restore, something like informix's ontape and logical logs. Thanks -- "And I'm happy, because you make me feel good, about me." - Melvin Udall - Martín Marqués email: [EMAIL PROTECTED] Santa Fe - Argentinahttp://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -
