Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread Thomas Kellerer
John R Pierce, 18.07.2013 21:20: >> 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 a

Re: [GENERAL] Hot Standby and Foreign Tables

2013-07-18 Thread Michael Paquier
On Thu, Jul 18, 2013 at 11:15 PM, Tim Kane wrote: > 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 apprec

Re: [GENERAL] LibreOffice Base and PostgreSQL Transactions

2013-07-18 Thread Don Parris
On Thu, Jul 18, 2013 at 5:01 PM, Joshua D. Drake wrote: > > 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 fou

Re: [GENERAL] Best Postgresql books

2013-07-18 Thread Steven Schlansker
PostgreSQL 9.0 High Performance: http://www.amazon.com/books/dp/184951030X On Jul 18, 2013, at 3:11 PM, Pedro Costa wrote: > Hi guys, > > Can anyone tell me the best books about postgresql? Specialy about tunning > and querys performances > Thanks > > > > Enviado do meu tablet Samsung

[GENERAL] Best Postgresql books

2013-07-18 Thread Pedro Costa
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] cron tasks in pg 9.3

2013-07-18 Thread Alvaro Herrera
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 ta

Re: [GENERAL] cron tasks in pg 9.3

2013-07-18 Thread Joe Van Dyk
On Thu, Jul 18, 2013 at 2:31 PM, Thomas Kellerer 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

Re: [GENERAL] cron tasks in pg 9.3

2013-07-18 Thread Thomas Kellerer
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 wi

[GENERAL] cron tasks in pg 9.3

2013-07-18 Thread Joe Van Dyk
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 ru

Re: [GENERAL] LibreOffice Base and PostgreSQL Transactions

2013-07-18 Thread Joshua D. Drake
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

[GENERAL] LibreOffice Base and PostgreSQL Transactions

2013-07-18 Thread Don Parris
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

Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread John R Pierce
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

Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread John R Pierce
On 7/18/2013 11:48 AM, Eduardo Morras wrote: On Thu, 18 Jul 2013 09:17:34 -0700 John R Pierce 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

Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread Thomas Kellerer
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 parame

Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread Eduardo Morras
On Thu, 18 Jul 2013 09:17:34 -0700 John R Pierce 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

Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread John R Pierce
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 Comput

Re: [GENERAL] Postgresql, sql client and I/O exceptions

2013-07-18 Thread Eduardo Morras
On Thu, 18 Jul 2013 10:20:07 -0400 Paul Maddock 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

Re: [GENERAL] Postgresql, sql client and I/O exceptions

2013-07-18 Thread Merlin Moncure
On Thu, Jul 18, 2013 at 9:20 AM, Paul Maddock 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 r

[GENERAL] Set cost for a specific index scan

2013-07-18 Thread Thomas Strunz
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 ind

[GENERAL] Postgresql, sql client and I/O exceptions

2013-07-18 Thread Paul Maddock
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

[GENERAL] Hot Standby and Foreign Tables

2013-07-18 Thread Tim Kane
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

Re: [GENERAL] Question re contribs of Julian Assange

2013-07-18 Thread Alvaro Herrera
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-ju

Re: [GENERAL] dynamic table names

2013-07-18 Thread Merlin Moncure
On Wed, Jul 17, 2013 at 3:39 PM, John Smith 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 ||

Re: [GENERAL] new instance of postgres on windows

2013-07-18 Thread raghu ram
On Thu, Jul 18, 2013 at 3:52 PM, Arvind Singh 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. > > > > postgresq

[GENERAL] new instance of postgres on windows

2013-07-18 Thread Arvind Singh
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 par