Re: [BUGS] BUG #3605: impossible loading
Christian PANEL wrote: > I have tried 7 mirrors sites (2 france, others usa and deutchland) that > totalize more than 7 hours of connection in several days and have enough. > My ISP is Free. I have soon dowload big files (15Mo) with it but perhaps > have they changed since that. > I precise I have tried FTP and HTTP. But how can I know who is > responsible but I think I'm not alone with this situation. We have many thousands of downloads every month, but unfortunately you're the first person who has reported this issue. > I want you to know this Situation. > For me the solution is to find someone who have fast-debit connection to > try again a last time. I think it was Heikki who suggested using a ftp program that can resume broken downloads - one suggestion would be Filezilla (http://filezilla-project.org). I haven't used it for a year or so, but it certainly used to be very good. You can download straight from one of the mirrors, eg: ftp://ftp3.fr.postgresql.org/pub/postgresql/ > Your response is a reason to see more over and that Postgree could be > quite interessant (because there is someone in the back) and is not like > many preytendly (free) freeware. There is a large and friendly community behind PostgreSQL - we're happy to help. > I'm responsible of a free french GIS software and want to evaluate > Postgree (possibly to integrate in it) Ahh, in which case you'll probably also want to look at PostGIS - http://www.postgis.org/ Regards, Dave ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[BUGS] partially effective revoke on pg_catalog
user depesz is superuser. i connect to depesz database, and: ([EMAIL PROTECTED]:5830) 14:20:34 [depesz] # revoke usage on schema pg_catalog from public; REVOKE now, i reconnect to the same database with test user (which is not superuser): ([EMAIL PROTECTED]:5830) 14:23:55 [depesz] > \d ERROR: permission denied for schema pg_catalog ([EMAIL PROTECTED]:5830) 14:23:57 [depesz] > select count(*) from pg_tables; count --- 48 (1 row) ([EMAIL PROTECTED]:5830) 14:23:59 [depesz] > select count(*) from pg_catalog.pg_tables; ERROR: permission denied for schema pg_catalog something looks weird here. search_path is default: ([EMAIL PROTECTED]:5830) 14:24:03 [depesz] > show search_path; search_path "$user",public (1 row) pg version - 8.3devel from cvs. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---(end of broadcast)--- TIP 1: 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: [BUGS] partially effective revoke on pg_catalog
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > # revoke usage on schema pg_catalog from public; > REVOKE This is not a supported operation. regards, tom lane ---(end of broadcast)--- TIP 1: 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: [BUGS] partially effective revoke on pg_catalog
On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote: > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > # revoke usage on schema pg_catalog from public; > > REVOKE > This is not a supported operation. ok, but i belive it should either dont allow admin to do so, or, if it does allow, it should behave more consistently. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [BUGS] partially effective revoke on pg_catalog
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote: >> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: >>> # revoke usage on schema pg_catalog from public; >>> REVOKE >> This is not a supported operation. > ok, but i belive it should either dont allow admin to do so, or, if it > does allow, it should behave more consistently. There are few "training wheels" for superuser mode. Try something like "delete from pg_proc" if you are looking for ways to break your database. regards, tom lane ---(end of broadcast)--- TIP 1: 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: [BUGS] partially effective revoke on pg_catalog
On Mon, Sep 10, 2007 at 11:17:21AM -0400, Tom Lane wrote: > > ok, but i belive it should either dont allow admin to do so, or, if it > > does allow, it should behave more consistently. > There are few "training wheels" for superuser mode. Try something like > "delete from pg_proc" if you are looking for ways to break your > database. i'm perfectly fine with "revoke from pg_catalog" not working/not allowed, but dont you think that the outcome should be a bit more consistent? if it would "break the database" - i'm happy with it. if it will reject hhe command as "it is not possible" - i'm happy with it. but now postgresql raports to user that revoke worked. and at first sight it actually does seem like it. but a second check showes that the revoke is not really 100% effective. again - i'm in no position to ask to give the ability to revoke the privileges. all i'm asking is to put some consistency - either break it, or forbid. but dont say "revoked" when it's not really true. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
