[GENERAL] Re: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! (nearly fixed)

2013-08-04 Thread Thomas Kellerer
Stephen Brearley, 02.08.2013 11:40: > I can change my registry reference to point to D:\..\9.2\data or > D:\..\9.2\data_old without any (apparently) undesirable consequences, > but I just can’t see my tables in the system, which makes me think I need to > do more than this. Why don't you use t

[GENERAL] Bottlenecks with large number of relation segment files

2013-08-04 Thread Amit Langote
Hello, I am looking the effect of having large number of relation files under $PGDATA/base/ (for example, in cases where I choose lower segment size using --with-segsize). Consider a case where I am working with a large database with large relations, for example a database similar in size to what

Re: [GENERAL] Migration from Symfoware to PostgreSQL-Constructor functions

2013-08-04 Thread raghu ram
> how to see list of system tables, functions, view and user defined tables, > functions, views. > > You can get more details from below URL: Extracting META information from PostgreSQL (INFORMATION_SCHEMA) Thanks & Regards Raghu Ram

Re: [GENERAL] Re: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! (nearly fixed)

2013-08-04 Thread BladeOfLight16
On Sat, Aug 3, 2013 at 7:16 AM, Alban Hertroys wrote: > They are cluster specific, as the roles are stored in the database. If you > switch between different data directories, that means you're switching the > available roles as well. And their details, such as passwords. You're also > switching

Re: [GENERAL] Why are stored procedures looked on so negatively?

2013-08-04 Thread Craig Ringer
On 08/02/2013 09:18 PM, Merlin Moncure wrote: > On Fri, Aug 2, 2013 at 1:49 AM, Chris Travers wrote: >> Here's my $0.02 >> >> Stored procedures have a bunch of problems historically. Part of this is >> because the interface traditionally is pretty spartan, and partly because >> some people take t

Re: [GENERAL] xlog min recovery request ... is past current point ...

2013-08-04 Thread Michael Paquier
On Fri, Aug 2, 2013 at 11:33 PM, Alberto Bussolin < alberto.busso...@edistar.com> wrote: > Hi, > i was testing a point in time recovery on a postgres 9.1.9. > > When processing the xlog i found out these log messages (on postgres.log): > > postgres@postgres[[local]] FATAL: the database system is

Re: [GENERAL] Exit code -1073741819

2013-08-04 Thread Craig Ringer
On 08/04/2013 02:41 AM, Carlos Henrique Reimer wrote: > Hi, > > I have a Windows box running Windows Server 2003 Enterprise Edition > Service Pack 2 with PostgreSQL 8.2.23 and getting a server crash while > trying to select a table: > > select * from "TOTALL.tt_est" where assina=' kdkd' ; > > Du

Re: [GENERAL] Migration from Symfoware to PostgreSQL-Constructor functions

2013-08-04 Thread Jayadevan M
Hi, System tables, views and most of the metadata can be retrieved from these views - http://www.postgresql.org/docs/9.2/static/information-schema.html Regards, Jayadevan On Sun, Aug 4, 2013 at 2:48 PM, sachin kotwal wrote: > Hello > > While migrating small application from Symfoware to Postgr

[GENERAL] Migration from Symfoware to PostgreSQL-Constructor functions

2013-08-04 Thread sachin kotwal
Hello While migrating small application from Symfoware to PostgreSQL. There are some constructor functions in Symfoware. Which I unable to execute in Symfoware database. If anyone knows how to execute constructor functions in Symfoware. how to see list of system tables, functions, view and user d