Re: [GENERAL] pgAdmin for ubuntu
On Wed, Jul 17, 2013 at 4:02 PM, Muhammad Bashir Al-Noimi mbno...@gmail.com wrote: Failed to fetch bzip2:/var/lib/apt/lists/partial/archive.ubuntu.com_ubuntu_dists_quantal-updates_main_binary-amd64_Packages Hash Sum mismatch I guess this is the problem. It happened to me sometimes when working behind a proxy, but I don't have a good workaround. It is better to ask to someone on an ubuntu mailing list. Luca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Reply: Reply: [GENERAL] ?????? [GENERAL] Can't create plpython language
Problem with ActivePython-2.7.2.5 is [postgres@lix stado]$ psql psql (9.3beta2) Type help for help. postgres=# create language plpython2u; ERROR: could not load library /opt/PostgreSQL/93b2src/lib/postgresql/plpython2.so: /opt/PostgreSQL/93b2src/lib/postgresql/plpython2.so: undefined symbol: PyObject_Bytes with environment variables as export PGDATA=/opt/PostgreSQL/pgdata/93b2src export PYTHONHOME=/opt/ActivePython-2.7 export PYTHONPATH=/opt/ActivePython-2.7/bin export PATH=/opt/PostgreSQL/93b2src/bin:$PYTHONHOME/bin:$PATH export LD_LIBRARY_PATH=$PYTHONHOME/lib:$LD_LIBRARY_PATH -- Original -- Sender: Raghavendraraghavendra@enterprisedb.com; Send time: Tuesday, Jul 16, 2013 4:53 PM To: guxiaobo1982guxiaobo1...@qq.com; Cc: Jovam...@amutu.com; Michael Paquiermichael.paqu...@gmail.com; pgsql-generalpgsql-general@postgresql.org; Asif Naeemasif.na...@enterprisedb.com; Subject: Re: Reply: [GENERAL] ?? [GENERAL] Can't create plpython language On Mon, Jul 15, 2013 at 7:10 PM, guxiaobo1982 guxiaobo1...@qq.com wrote: It works with ActivePython 3.2.2.3, Thanks for notifying. but not ActivePython 2.7.2.5. No idea... :), I tried AP 3.2 with PG 9.2 PG 9.3B it went fine for me. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ -- Original -- From: Raghavendraraghavendra@enterprisedb.com; Date: Jul 11, 2013 To: guxiaobo1982guxiaobo1...@qq.com; Cc: Jovam...@amutu.com; Michael Paquiermichael.paqu...@gmail.com; pgsql-generalpgsql-general@postgresql.org; Asif Naeemasif.na...@enterprisedb.com; Subject: Re: Reply: [GENERAL] ?? [GENERAL] Can't create plpython language On Wed, Jul 10, 2013 at 7:36 AM, guxiaobo1982 guxiaobo1...@qq.com wrote: I am using PostgreSQL 9.3 beta 2 [postgres@lix Multicorn-master]$ psql psql (9.3beta2) Type help for help. postgres=# It does not work with ActivePython3.2(ActivePython-3.2.2.3-linux-x86_64.tar.gz), Which version of PostgreSQL are you running? Sorry for being late on this email. I overlooked the version you were pointing. I didn't test on PG 9.3Beta, I did on PG 9.2 after looking your error showing PG 9.2.4 [postgres@lix PostgreSQL]$ psql Password: psql (9.2.4) Type help for help. postgres=# create language plpython2u; ERROR: could not access file $libdir/plpython2: No such file or directory postgres=# create language plpython3u; ERROR: could not access file $libdir/plpython3: No such file or directory Later, I began testing it with PG 9.3beta and encountered same error message as you have shared here. Did some analysis and finally succeeded to create language plpython3u with AP-3.2, however with not many tweaks in compilation.(Steps might be arguing. Pardon me). Despite the fact that I have ActivePython-3.2 on my system, source compilation was looking for shared library. Hence compiled explicitly with shared_libpython=yes. Pre-Steps: (Assuming you have ActivePython 3.2) cd /opt/ActivePython-3.2/bin/ cp python3.2-config python-config cp python3. python Test: export PATH=/opt/ActivePython-3.2/bin:$PATH # which python /opt/ActivePython-3.2/bin/python # which python-config /opt/ActivePython-3.2/bin/python-config Steps: 1. Install PG 9.3 beta with below steps: export PATH=/opt/ActivePython-3.2/bin:$PATH ./configure --prefix=/usr/local/pg93b3 --with-python make shared_libpython=yes make shared_libpython=yes install 2. After installation you should see below files in your PG installation Path: [root@localhost pg93b3]# pwd /usr/local/pg93b3 [root@localhost pg93b3]# find . | grep python ./lib/postgresql/plpython3.so ./share/postgresql/extension/plpython3u--unpackaged--1.0.sql ./share/postgresql/extension/plpython3u--1.0.sql ./share/postgresql/extension/plpython3u.control 3. Now, create new cluster using INITDB 4. Before starting the cluster set the PYTHONHOME, PYTHONPATH, LD_LIBRARY_PATH export PYTHONHOME=/opt/ActivePython-3.2/ export PYTHONPATH=/opt/ActivePython-3.2/bin:$PATH export LD_LIBRARY_PATH=/opt/ActivePython-3.2/lib:$LD_LIBRARY_PATH 5. Start the cluster and create the language: /usr/local/pg93b3/bin/pg_ctl -D /usr/local/pg93b3/data/ start -bash-4.1$ psql -p psql (9.3beta1) Type help for help. postgres=# create language plpython3u; CREATE LANGUAGE Out of my analysis on the issue, Asif Naeem from our Dev group shared his valuable thoughts to conclude this. Thanks Asif. Question still in mind, Why plpython depends on Shared Libraries (.so) ? http://www.postgresql.org/docs/9.3/static/install-requirements.html --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
Re: [GENERAL] dynamic table names
On Jul 17, 2013, at 22:39, John Smith jayzee.sm...@gmail.com wrote: so my query goes like so: execute 'select * from ' || tabname::regclass || ' where firstname = john' into e; Are those quotes around 'john' double-quotes (for identifiers) or double single-quotes (for literals)? They look like double-quotes to me, so unless your table has a column named john (and lowercase at that) that would fail. It's probably not what you meant anyway. Does this fare any better? execute 'select * from ' || tabname::regclass || ' where firstname = ''john''' into e; but i am getting an error: ERROR: syntax error at or near 'select * from ' at character 9 Do you always get that error or do you only get it with certain table names? If so, which ones? Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] new instance of postgres on windows
Hello and greetings, I want to install postgresql for use as the backend to a Windows application. This seems to be no problem if postgresql is NOT already installed on the system. which is not in this case. postgresql is already installed and unless the command line parameters contain the superpassword etc of the existing installation , the install fails. As I will likely never know the superpassword or other account details of any pre-existing postgresql instances and the machine owners may not either. How to then proceed and install a new instance that can be used by our application. Window 7 Postgres 9.3 beta regards
Re: [GENERAL] new instance of postgres on windows
On Thu, Jul 18, 2013 at 3:52 PM, Arvind Singh arvin...@hotmail.com wrote: Hello and greetings, I want to install postgresql for use as the backend to a Windows application. This seems to be no problem if postgresql is NOT already installed on the system. which is not in this case. postgresql is already installed and unless the command line parameters contain the superpassword etc of the existing installation , the install fails. As I will likely never know the superpassword or other account details of any pre-existing postgresql instances and the machine owners may not either. How to then proceed and install a new instance that can be used by our application. Window 7 Postgres 9.3 beta The password you need to reset is at the operating system level. To do this on Windows, do the following: 1) Right click on the 'My Computer' desktop icon ( or if the icon is not on the desktop, open the start menu and right click on the 'My Computer' menu item) 2) Choose 'Manage' from the pop up menu 3) Expand the 'Local Users and Groups' folder 4) Expand the 'Users' folder 5) On the right hand side of the screen, you will see all the users defined on the system. 6) You can right click on the postgres user name and choose 'Set Password' and then change it to something else OR You can delete the user and then have the installer recreate the user. You will need to be logged into the computer as an administrative user to do the above. Thanks Regards Raghu Ram
Re: [GENERAL] dynamic table names
On Wed, Jul 17, 2013 at 3:39 PM, John Smith jayzee.sm...@gmail.com wrote: guys, have to use legacy 8.1. i have 100,000 tables in a schema that need to be queried (optimizing this by combining them into one will have to wait). so my query goes like so: execute 'select * from ' || tabname::regclass || ' where firstname = john' into e; but i am getting an error: ERROR: syntax error at or near 'select * from ' at character 9 when debugging EXECUTE, I generally stage the string first -- this gives me the opportunity to see the whole query. q := 'select * from ' || tabname::regclass || ' where firstname = john' into e; RAISE NOTICE q; EXECUTE q; then the problem is usually a lot more obvious. By the way, I'm very sympathetic to being stuck on older versions: the company I work for just spent some major bucks migrating to 9.2 and had I not shown up probably would have dropped postgres completely. merlin -- 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] Question re contribs of Julian Assange
ERR ORR escribió: I noticed on the postgresql website that a certain *Julian Assange* is mentioned among the contributors to Postgresql. Out of curiosity, could anybody post in short what exactly he contributed to the DB? http://herraiz.org/blog/2011/07/07/software-projects-alzheimer-julian-assanges-lost-contributions/ -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Hot Standby and Foreign Tables
Hi all, I'm currently playing a few ideas out in my head and wanted to see if this was feasible. There may be some limitation I am not aware of. I would like to create a foreign table into a hot standby instance using FDW's. I appreciate that the hot standby is always going to be read-only, and that foreign tables are currently read-only anyway. Can anyone tell me if there is any reason this wouldn't work? I'm unable to test it just yet as I've not setup replication, nor am I on a recent enough postgres. yet. ;-) While I'm at it, is there any facility (future?) to provide a *foreign* * schema* variant - such that I could access an entire schema using FDW's? Cheers, Tim
[GENERAL] Set cost for a specific index scan
Hi all, I'm using an open-source extension that creates an index for special type of search and you need to use a custom operator to run queries. Anyway If I run an according query with multiple filters as example also range of primary key PostgreSQL almost always selects this 3rd party index as the first index to scan. However this index is almost always slower than a normal index. This leads to queries with a filter primary_key 10 taking several seconds because the 3rd party index taking that much time. In the explain plan it is visible that PostgreSQL seems to prefer this index over other indexes. Is there any way to increase the cost for this specific index (or operator) so that any other index is always used first? Beat Regards, Thomas
[GENERAL] Postgresql, sql client and I/O exceptions
I am having trouble with postgresql connection. I am using squirrel sql client to write sql code for data qc'ing. On many occasions this has happened. It closes my connection on my client and stops my sql transaction. There are roughly 3 million records in the database I am editing. Version of Postgresql: psql (PostgreSQL) 9.2.4 JDBC for squirrel sql client: postgresql-9.2-1003.jdbc4.jar -- *syslog* 276 Jul 18 09:10:08 test-minapps kernel: [173502.656976] postgres[15212]: segfault at 7f4c34e8a44e ip 7f4c02d13605 sp 7fff92ba69f0 error 4 in postgres[7f4c02c86000+54e000] 277 Jul 18 09:10:12 test-minapps lsassd[1136]: 0x7f1607fff700:Error code 40286 occurred during attempt 0 of a ldap search. Retrying. *postgresql log* * 2013-07-18 09:10:24 EDT LOG: terminating any other active server processes 2013-07-18 09:10:24 EDT WARNING: terminating connection because of crash of another server process 2013-07-18 09:10:24 EDT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. * ** ~20** 2013-07-18 09:10:26 EDT LOG: all server processes terminated; reinitializing 2013-07-18 09:10:28 EDT LOG: database system was interrupted; last known up at 2013-07-18 09:03:54 EDT 2013-07-18 09:10:28 EDT LOG: database system was not properly shut down; automatic recovery in progress 2013-07-18 09:10:28 EDT LOG: redo starts at 39/BBAE7D60 2013-07-18 09:10:29 EDT LOG: record with zero length at 39/BD17A7D8 2013-07-18 09:10:29 EDT LOG: redo done at 39/BD17A7A8 2013-07-18 09:10:29 EDT LOG: last completed transaction was at log time 2013-07-18 09:10:10.968978-04 2013-07-18 09:11:08 EDT LOG: database system is ready to accept connections * *squirrel sql log* Error: An I/O error occured while sending to the backend. SQLState: 08006 ErrorCode: 0 - I'm researching the issue myself, but if you might know the cause it would help me tremendously. -- Paul Anthony Maddock
Re: [GENERAL] Postgresql, sql client and I/O exceptions
On Thu, Jul 18, 2013 at 9:20 AM, Paul Maddock paul.madd...@spidasoftware.com wrote: I am having trouble with postgresql connection. I am using squirrel sql client to write sql code for data qc'ing. On many occasions this has happened. It closes my connection on my client and stops my sql transaction. There are roughly 3 million records in the database I am editing. Version of Postgresql: psql (PostgreSQL) 9.2.4 JDBC for squirrel sql client: postgresql-9.2-1003.jdbc4.jar -- syslog 276 Jul 18 09:10:08 test-minapps kernel: [173502.656976] postgres[15212]: segfault at 7f4c34e8a44e ip 7f4c02d13605 sp 7fff92ba69f0 error 4 in postgres[7f4c02c86000+54e000] 277 Jul 18 09:10:12 test-minapps lsassd[1136]: 0x7f1607fff700:Error code 40286 occurred during attempt 0 of a ldap search. Retrying. postgresql log 2013-07-18 09:10:24 EDT LOG: terminating any other active server processes 2013-07-18 09:10:24 EDT WARNING: terminating connection because of crash of another server process 2013-07-18 09:10:24 EDT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. * ~20 2013-07-18 09:10:26 EDT LOG: all server processes terminated; reinitializing 2013-07-18 09:10:28 EDT LOG: database system was interrupted; last known up at 2013-07-18 09:03:54 EDT 2013-07-18 09:10:28 EDT LOG: database system was not properly shut down; automatic recovery in progress 2013-07-18 09:10:28 EDT LOG: redo starts at 39/BBAE7D60 2013-07-18 09:10:29 EDT LOG: record with zero length at 39/BD17A7D8 2013-07-18 09:10:29 EDT LOG: redo done at 39/BD17A7A8 2013-07-18 09:10:29 EDT LOG: last completed transaction was at log time 2013-07-18 09:10:10.968978-04 2013-07-18 09:11:08 EDT LOG: database system is ready to accept connections squirrel sql log Error: An I/O error occured while sending to the backend. SQLState: 08006 ErrorCode: 0 - I'm researching the issue myself, but if you might know the cause it would help me tremendously. database is crashing. typical culprits are 3rd party extensions, userland C routines, bad hardware, non-up-to-date postgres, etc. assuming none of those apply to you, next steps are to use various debugging tools (gdb especially and strace), and logging. Ideally you could grab a core for postgres and post a backtrace. Even more ideally you could provide a reproducible crash case. merlin -- 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] Postgresql, sql client and I/O exceptions
On Thu, 18 Jul 2013 10:20:07 -0400 Paul Maddock paul.madd...@spidasoftware.com wrote: I am having trouble with postgresql connection. I am using squirrel sql client to write sql code for data qc'ing. On many occasions this has happened. It closes my connection on my client and stops my sql transaction. There are roughly 3 million records in the database I am editing. Version of Postgresql: psql (PostgreSQL) 9.2.4 JDBC for squirrel sql client: postgresql-9.2-1003.jdbc4.jar -- *syslog* 276 Jul 18 09:10:08 test-minapps kernel: [173502.656976] postgres[15212]: segfault at 7f4c34e8a44e ip 7f4c02d13605 sp 7fff92ba69f0 error 4 in postgres[7f4c02c86000+54e000] 277 Jul 18 09:10:12 test-minapps lsassd[1136]: 0x7f1607fff700:Error code 40286 occurred during attempt 0 of a ldap search. Retrying. *postgresql log* * 2013-07-18 09:10:24 EDT LOG: terminating any other active server processes 2013-07-18 09:10:24 EDT WARNING: terminating connection because of crash of another server process 2013-07-18 09:10:24 EDT DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. * ** ~20** 2013-07-18 09:10:26 EDT LOG: all server processes terminated; reinitializing 2013-07-18 09:10:28 EDT LOG: database system was interrupted; last known up at 2013-07-18 09:03:54 EDT 2013-07-18 09:10:28 EDT LOG: database system was not properly shut down; automatic recovery in progress 2013-07-18 09:10:28 EDT LOG: redo starts at 39/BBAE7D60 2013-07-18 09:10:29 EDT LOG: record with zero length at 39/BD17A7D8 2013-07-18 09:10:29 EDT LOG: redo done at 39/BD17A7A8 2013-07-18 09:10:29 EDT LOG: last completed transaction was at log time 2013-07-18 09:10:10.968978-04 2013-07-18 09:11:08 EDT LOG: database system is ready to accept connections * *squirrel sql log* Error: An I/O error occured while sending to the backend. SQLState: 08006 ErrorCode: 0 - I'm researching the issue myself, but if you might know the cause it would help me tremendously. If it's under Linux, check that Out of Memory Killer don't slain some postmaster process. Disable it and try again. -- Paul Anthony Maddock --- --- Eduardo Morras emorr...@yahoo.es -- 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] new instance of postgres on windows
On 7/18/2013 3:48 AM, raghu ram wrote: The password you need to reset is at the operating system level. To do this on Windows, do the following: 1) Right click on the 'My Computer' desktop icon ( or if the icon is not on the desktop, open the start menu and right click on the 'My Computer' menu item) 2) Choose 'Manage' from the pop up menu 3) Expand the 'Local Users and Groups' folder 4) Expand the 'Users' folder 5) On the right hand side of the screen, you will see all the users defined on the system. 6) You can right click on the postgres user name and choose 'Set Password' and then change it to something else OR You can delete the user and then have the installer recreate the user. You will need to be logged into the computer as an administrativeuserto do the above. which will break the existing install -- john r pierce 37N 122W somewhere on the middle of the left coast
Re: [GENERAL] new instance of postgres on windows
On Thu, 18 Jul 2013 09:17:34 -0700 John R Pierce pie...@hogranch.com wrote: which will break the existing install Throw Windows away defenestrating the server Feed a dvd with last FreeBSD or Linux distro or Unix U Want. Restart. Install from dvd. Install Postgres and whatever you want the times you want with the configuration you want. Run. --- --- Eduardo Morras emorr...@yahoo.es -- 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] new instance of postgres on windows
Arvind Singh wrote on 18.07.2013 12:22: I want to install postgresql for use as the backend to a Windows application. This seems to be no problem if postgresql is NOT already installed on the system. which is not in this case. postgresql is already installed and unless the command line parameters contain the superpassword etc of the existing installation , the install fails. As I will likely never know the superpassword or other account details of any pre-existing postgresql instances and the machine owners may not either. How to then proceed and install a new instance that can be used by our application. It's unclear to me if you want to re-use the existing installation and create a new cluser (aka data directory by running initdb or if you want to install a completely new version along the original one (with it's own server and data directory) If you want to install a completely new instance, just put it into a different directory, and given the service a different name. Newer Postgres versions don't need a dedicated Windows user account any more. I usually don't use the installer any more, but I simply unzip the binary distribution, then run initdb with a directory of my choice (making sure the privileges are correctly setup) and then use pg_ctl to register the service. The only thing you need to make sure is to change the port in postgresql.conf before starting the service. Something like this (batch file commands): echo superuserpassword pwfile.txt unzip postgresql-9.2.4-1-windows-binaries.zip -d c:\MyApp\Postgres mkdir c:\MyApp\Data c:\MyApp\Postgres\bin\initdb -D c:\MyApp\Data -U postgres -pwfile=pwfile.txt -E UTF8 -A md5 c:\MyApp\Postgres\bin\pg_ctl register -N my-app-postgres -S auto Again: you have to make sure that the data directory has all the right privileges! -- 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] new instance of postgres on windows
On 7/18/2013 11:48 AM, Eduardo Morras wrote: On Thu, 18 Jul 2013 09:17:34 -0700 John R Piercepie...@hogranch.com wrote: which will break the existing install Throw Windows away defenestrating the server Feed a dvd with last FreeBSD or Linux distro or Unix U Want. Restart. Install from dvd. Install Postgres and whatever you want the times you want with the configuration you want. Run. join unemployment line if you work at a Windows shop, or are selling an end user application intended for Windows users. -- john r pierce 37N 122W somewhere on the middle of the left coast -- 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] new instance of postgres on windows
On 7/18/2013 12:03 PM, Thomas Kellerer wrote: If you want to install a completely new instance, just put it into a different directory, and given the service a different name. Newer Postgres versions don't need a dedicated Windows user account any more. I usually don't use the installer any more, but I simply unzip the binary distribution, then run initdb with a directory of my choice (making sure the privileges are correctly setup) and then use pg_ctl to register the service. The only thing you need to make sure is to change the port in postgresql.conf before starting the service. yeah, for an application 'embedded' install, that's DEFINITELY the way to go. package up all the postgresql files with your app installer, and install them in a folder under your app (C:\Program Files\MyName\MyApp\MyPostgresql\... or whatever), use a app unique service name and pick a alternate port number.Only challenge is where to put the data directory I don't think these should be under C:\Program Files under ANY conditions, but they don't belong in the current user's %USERPROFILE%\AppData\Local either... I note newer Windows has a C:\ProgramData, so perhaps thats the 'right' default choice? -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] LibreOffice Base and PostgreSQL Transactions
Hi all, I have a 4-table DB in PostgreSQL to which I connect using LibreOffice Base. I have a form with 2 subforms in place that allows me to: Select an existing entity (from the ENTITY table) Add a new financial transaction (to the TRANSREC table) Add new line items for each transaction (to the TRANSDETAILS table). I would like to take advantage of PostGRESQL's underlying transaction (start, rollback, commit, etc.) capability to ensure that a given transaction and its line items are entered as one single transaction - or allow me to rollback when encountering a glitch. I just don't know how to implement that using Base as a front-end (or if it's possible). Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just haven't really found anything yet. Many thanks in advance, Don -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ https://www.xing.com/profile/Don_Parrishttp://www.linkedin.com/in/dcparris GPG Key ID: F5E179BE
Re: [GENERAL] LibreOffice Base and PostgreSQL Transactions
On 07/18/2013 01:44 PM, Don Parris wrote: Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just haven't really found anything yet. Many thanks in advance, Hello, Maybe this will help: http://forum.openoffice.org/en/forum/viewtopic.php?f=45t=1426 JD -- Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc For my dreams of your image that blossoms a rose in the deeps of my heart. - W.B. Yeats -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] cron tasks in pg 9.3
Will the custom worker support in 9.3 let me put cron-like tasks into postgresql? I have a lot of database functions that should run every few seconds, every minute, every hour, once a week, etc. Right now, I always have to have exactly one machine setup with cron tasks that tells postgresql to run whatever functions are necessary. It would be super to let postgresql handle all of that. Joe
Re: [GENERAL] cron tasks in pg 9.3
Joe Van Dyk wrote on 18.07.2013 23:23: Will the custom worker support in 9.3 let me put cron-like tasks into postgresql? I have a lot of database functions that should run every few seconds, every minute, every hour, once a week, etc. Right now, I always have to have exactly one machine setup with cron tasks that tells postgresql to run whatever functions are necessary. It would be super to let postgresql handle all of that. What about pgAgent? http://www.pgadmin.org/docs/1.16/pgagent.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] cron tasks in pg 9.3
On Thu, Jul 18, 2013 at 2:31 PM, Thomas Kellerer spam_ea...@gmx.net wrote: Joe Van Dyk wrote on 18.07.2013 23:23: Will the custom worker support in 9.3 let me put cron-like tasks into postgresql? I have a lot of database functions that should run every few seconds, every minute, every hour, once a week, etc. Right now, I always have to have exactly one machine setup with cron tasks that tells postgresql to run whatever functions are necessary. It would be super to let postgresql handle all of that. What about pgAgent? http://www.pgadmin.org/docs/1.**16/pgagent.htmlhttp://www.pgadmin.org/docs/1.16/pgagent.html That falls into the category of having to run another singleton (exactly one instance running) bit of software at all times. Not much difference between pgagent and cron, as far as I can tell. I already always have a single postgresql master running at all times, it would be awesome the postgresql master process could be used to fire off these scheduled tasks. It seems like that would simplify many systems. Joe
Re: [GENERAL] cron tasks in pg 9.3
Joe Van Dyk wrote: Will the custom worker support in 9.3 let me put cron-like tasks into postgresql? I have a lot of database functions that should run every few seconds, every minute, every hour, once a week, etc. Right now, I always have to have exactly one machine setup with cron tasks that tells postgresql to run whatever functions are necessary. Yes, you should be able to do that, but there's no scheduling code yet. There has been talk about porting the execution part (i.e. no UI) of pgagent into a bgworker, but so far I don't know of any code. If you want your tasks to just run some queries, that's easy to arrange. If you want to do things like run separate processes (say pg_dump) it might be a bit more involved. The new facilities in 9.4 that let you start dynamic bgworkers would ease things even more. -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Best Postgresql books
Hi guys, Can anyone tell me the best books about postgresql? Specialy about tunning and querys performances Thanks Enviado do meu tablet Samsung Note
Re: [GENERAL] Best Postgresql books
PostgreSQL 9.0 High Performance: http://www.amazon.com/books/dp/184951030X On Jul 18, 2013, at 3:11 PM, Pedro Costa pedrocostaa...@sapo.pt wrote: Hi guys, Can anyone tell me the best books about postgresql? Specialy about tunning and querys performances Thanks Enviado do meu tablet Samsung Note -- 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] LibreOffice Base and PostgreSQL Transactions
On Thu, Jul 18, 2013 at 5:01 PM, Joshua D. Drake j...@commandprompt.comwrote: On 07/18/2013 01:44 PM, Don Parris wrote: Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just haven't really found anything yet. Many thanks in advance, Hello, Maybe this will help: http://forum.openoffice.org/**en/forum/viewtopic.php?f=45t=**1426http://forum.openoffice.org/en/forum/viewtopic.php?f=45t=1426 JD Thanks Josh, that helps a little. I get the impression from Drew's discussion that it is possible to choose between creating stored procedures in LO Basic and the PGSQL native procedures. Is that correct? He gives no examples of how to use the MySQL triggers/procedures, so I am not sure how to ensure that, as I enter my data in the form in Base, it gets held until I am ready to hit submit. I know very little of LO/OO Basic - or of stored procedures, for that matter. So it looks like I've got a bit of reading to do.
