Re: [GENERAL] Hosting Account with PostgreSQL and PHP?
Hi, I have sign an account with HostNine.com, but PostgreSQL version is 8.1 and don't allow triggers... I must to change host, the web app is using triggers... Anyone know a host that have triggers available? Best Regards, On Sun, Feb 14, 2010 at 3:34 PM, John DeSoi de...@pgedit.com wrote: On Feb 13, 2010, at 4:09 PM, Andre Lopes wrote: I need an hosting account with PostgreSQL and PHP. I have signed an account with HostNine.com, but the PostgreSQL is the 8.1, and don't allow to create Languages and Triggers, so I can't get the website working... Please tell me if you know a good hosting with PostgreSQL that allow Triggers and all functionalities og PostgreSQL. You can find a list of hosting providers here: http://www.postgresql.org/support/professional_hosting If you are looking for shared hosting, I doubt you'll find any that will let you create languages. But if you need to create triggers with SQL or pl/pgsql, that should not be a problem. Of course, many offer VPS hosting where you could setup Postgres yourself and configure it any way you like. John DeSoi, Ph.D.
Re: [GENERAL] Hosting Account with PostgreSQL and PHP?
On Feb 13, 2010, at 4:09 PM, Andre Lopes wrote: I need an hosting account with PostgreSQL and PHP. I have signed an account with HostNine.com, but the PostgreSQL is the 8.1, and don't allow to create Languages and Triggers, so I can't get the website working... Please tell me if you know a good hosting with PostgreSQL that allow Triggers and all functionalities og PostgreSQL. You can find a list of hosting providers here: http://www.postgresql.org/support/professional_hosting If you are looking for shared hosting, I doubt you'll find any that will let you create languages. But if you need to create triggers with SQL or pl/pgsql, that should not be a problem. Of course, many offer VPS hosting where you could setup Postgres yourself and configure it any way you like. John DeSoi, Ph.D. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] The easiest and robust way of configuring password pass through mechanism..
Hi, I am aware of now almost all the authentication mechanisms that PostGreSQL supports. My basic requirement is to don't ask for password (allowed users in pg_hba file) when user connects to the server. What could be the easiest and robust method to configure this? I am looking for passing through the password so that users need not to enter it everytime they connects. Thanks, Dipti
[GENERAL] tuning bgwriter in 8.4.2
We recently upgraded to 8.4.2 and I'm trying to make sure our bgwriter is working as well as it can. Based on: # select * from pg_stat_bgwriter ; checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc ---+-++---+--+-+--- 804 | 2 | 39171885 | 22562 | 211 |24759656 | 4488627 (1 row) ...I'm not sure that it is, because as I understand things, assuming I don't keep updating the same pages then buffers_backend should be a small percentage of buffers_alloc, and buffers_clean should be larger than it is compared to buffers_checkpoint. Is my understanding correct? My checkpoints are spread exactly 5 minutes apart, and a typical checkpoint log entry looks like: checkpoint complete: wrote 48289 buffers (3.7%); 0 transaction log file(s) added, 0 removed, 14 recycled; write=149.872 s, sync=0.378 s, total=150.256 s The only bgwriter tunable we've adjusted so far is bgwriter_lru_maxpages = 500, though we've also set checkpoint_segments = 768 (not that we need it that high, but we have the space on the wal volume.)
[GENERAL] Kerberos library update
Hi I'm trying to find out when a version of PostgreSQL will be available that includes the Kerberos library (krb5_32.dll) version 1.6.4. Is Postgres currently being tested with version 1.6.4 of the Kerberos library? I couldn't find this information anywhere. Prasanna Sukumar OPNET Technologies Bethesda, MD _ Hotmail: Powerful Free email with security by Microsoft. https://signup.live.com/signup.aspx?id=60969
Re: [GENERAL] tuning bgwriter in 8.4.2
On Feb 14, 2010, at 10:25 AM, Ben Chobot wrote: We recently upgraded to 8.4.2 and I'm trying to make sure our bgwriter is working as well as it can. Based on: # select * from pg_stat_bgwriter ; checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc ---+-++---+--+-+--- 804 | 2 | 39171885 | 22562 | 211 |24759656 | 4488627 (1 row) ...I'm not sure that it is, because as I understand things, assuming I don't keep updating the same pages then buffers_backend should be a small percentage of buffers_alloc, and buffers_clean should be larger than it is compared to buffers_checkpoint. Is my understanding correct? My checkpoints are spread exactly 5 minutes apart, and a typical checkpoint log entry looks like: checkpoint complete: wrote 48289 buffers (3.7%); 0 transaction log file(s) added, 0 removed, 14 recycled; write=149.872 s, sync=0.378 s, total=150.256 s The only bgwriter tunable we've adjusted so far is bgwriter_lru_maxpages = 500, though we've also set checkpoint_segments = 768 (not that we need it that high, but we have the space on the wal volume.) I should have added that those 211 maxwritten_clean entries came about before we set bgwriter_lru_maxpages to 500. And the 2 requested checkpoints came with the initial slony load.
Re: [GENERAL] Function that creates a custom (temporary) table AND returns a pointer to it = impossible in pg?
Thank you for the link Andreas. It was helpfull, but still not quite what I need. Regards, Davor A. Kretschmer andreas.kretsch...@schollglas.com wrote in message news:20100212114635.gb25...@a-kretschmer.de... In response to Davor J. : What I want is something similar to this: Basically, what I want is a similar function f() that returns me a pointer to the table which I can use in some query like this: SELECT * FROM regclass(f()); Currently, this query only gives me one row 'tbl_temp'..., but not what I want: SELECT * FROM tbl_temp; Can this be done in Postgres? Take a look at http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: - Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] The easiest and robust way of configuring password pass through mechanism..
dipti shah wrote: Hi, I am aware of now almost all the authentication mechanisms that PostGreSQL supports. My basic requirement is to don't ask for password (allowed users in pg_hba file) when user connects to the server. What could be the easiest and robust method to configure this? I am looking for passing through the password so that users need not to enter it everytime they connects. are your users on the same computer as the database server, and connecting via unix socket as their unix account only? if so, LOCAL ALL ALL IDENT SAMEUSER (leave out SAMEUSER on 8.4, its implied with IDENT). this relies on unix authentication, and unix user joe will only be able to connect as database user joe. or, if the users are connecting via tcp/ip from specific hosts, and you can trust all users on those hosts HOST ALL someusername some.ip.addr TRUST or... if your users are always connecting via libpq. you can use $HOME/.pgpasswd per http://www.postgresql.org/docs/current/static/libpq-pgpass.html to specify passwords, when you do this, the application programs won't need to supply them. I don't know if this works with clients like JDBC, however. finally, you can use ssl client certificates, this is the most complex to setup, see http://www.postgresql.org/docs/current/static/libpq-ssl.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Hosting Account with PostgreSQL and PHP?
From the list I already sent, I'm certain this one allows triggers: http://www.a2hosting.com/database/postgresql-hosting I can also setup such an account for you, but I can't beat their price of $5.72 a month :) On Feb 14, 2010, at 10:44 AM, Andre Lopes wrote: Hi, I have sign an account with HostNine.com, but PostgreSQL version is 8.1 and don't allow triggers... I must to change host, the web app is using triggers... Anyone know a host that have triggers available? Best Regards, On Sun, Feb 14, 2010 at 3:34 PM, John DeSoi de...@pgedit.com wrote: On Feb 13, 2010, at 4:09 PM, Andre Lopes wrote: I need an hosting account with PostgreSQL and PHP. I have signed an account with HostNine.com, but the PostgreSQL is the 8.1, and don't allow to create Languages and Triggers, so I can't get the website working... Please tell me if you know a good hosting with PostgreSQL that allow Triggers and all functionalities og PostgreSQL. You can find a list of hosting providers here: http://www.postgresql.org/support/professional_hosting If you are looking for shared hosting, I doubt you'll find any that will let you create languages. But if you need to create triggers with SQL or pl/pgsql, that should not be a problem. Of course, many offer VPS hosting where you could setup Postgres yourself and configure it any way you like. John DeSoi, Ph.D. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Hosting Account with PostgreSQL and PHP?
Yeah, I was just going to recommend them; I went through the exact same thing a few months ago and got the same advice. HostNine looks great, but an [very] out of date Postgres isn't very helpful. I've enjoyed A2 since I signed up, and it doesn't hurt that they're relatively local (30 miles away) for me to boot! :) Raymond On 02/14/2010 07:11 PM, John DeSoi wrote: From the list I already sent, I'm certain this one allows triggers: http://www.a2hosting.com/database/postgresql-hosting I can also setup such an account for you, but I can't beat their price of $5.72 a month :) On Feb 14, 2010, at 10:44 AM, Andre Lopes wrote: Hi, I have sign an account with HostNine.com, but PostgreSQL version is 8.1 and don't allow triggers... I must to change host, the web app is using triggers... Anyone know a host that have triggers available? Best Regards, On Sun, Feb 14, 2010 at 3:34 PM, John DeSoide...@pgedit.com wrote: On Feb 13, 2010, at 4:09 PM, Andre Lopes wrote: I need an hosting account with PostgreSQL and PHP. I have signed an account with HostNine.com, but the PostgreSQL is the 8.1, and don't allow to create Languages and Triggers, so I can't get the website working... Please tell me if you know a good hosting with PostgreSQL that allow Triggers and all functionalities og PostgreSQL. You can find a list of hosting providers here: http://www.postgresql.org/support/professional_hosting If you are looking for shared hosting, I doubt you'll find any that will let you create languages. But if you need to create triggers with SQL or pl/pgsql, that should not be a problem. Of course, many offer VPS hosting where you could setup Postgres yourself and configure it any way you like. John DeSoi, Ph.D. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] unable to restore from a pgdump file
Thanks, Steve. You are exactly right. pg_restore was the right command to use! Janet On Feb 13, 2010, at 7:36 PM, Janet S Jacobsen wrote: Hi. I am trying to restore a database from a pgdump file, something that I've sucessfully done before. I created a new database cluster, created the database that I want to restore using create database subptf with template = template0; and then I tried to restore the database using ./psql subptf subptf.pgdump The first part of what I get is ERROR: syntax error at or near PGDMP I'd guess that you created the dump in custom format, rather than sql format. If so, you'd need to use pg_restore to restore it rather than psql. Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] The easiest and robust way of configuring password pass through mechanism..
Thanks John for reply. Users can connect to database server in either way(from same computer or remote). Currently by default all users are able to connect to database as pg_hba file has been configured to TRUST for all users. I am planning to remove these all users and want only specific groups and users to connect to database server. I haven't configured the server so I don't know from where to start. Thanks, Dipti On Mon, Feb 15, 2010 at 12:21 AM, John R Pierce pie...@hogranch.com wrote: dipti shah wrote: Hi, I am aware of now almost all the authentication mechanisms that PostGreSQL supports. My basic requirement is to don't ask for password (allowed users in pg_hba file) when user connects to the server. What could be the easiest and robust method to configure this? I am looking for passing through the password so that users need not to enter it everytime they connects. are your users on the same computer as the database server, and connecting via unix socket as their unix account only? if so, LOCAL ALL ALL IDENT SAMEUSER (leave out SAMEUSER on 8.4, its implied with IDENT). this relies on unix authentication, and unix user joe will only be able to connect as database user joe. or, if the users are connecting via tcp/ip from specific hosts, and you can trust all users on those hosts HOST ALL someusername some.ip.addr TRUST or... if your users are always connecting via libpq. you can use $HOME/.pgpasswd per http://www.postgresql.org/docs/current/static/libpq-pgpass.html to specify passwords, when you do this, the application programs won't need to supply them. I don't know if this works with clients like JDBC, however. finally, you can use ssl client certificates, this is the most complex to setup, see http://www.postgresql.org/docs/current/static/libpq-ssl.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general