[GENERAL] Type casting text to Numeric - Query Error

have your suggestion/solutions please? Regards, Vikram A

Re: [GENERAL] Type casting text to Numeric - Query Error

Dear Pavel, Thank you. Now it is not possible to use separate columns. The same works at MYSQL with out casting. But here it is so. We have used CAST and works fine. Thank you vikram From: Pavel Stehule pavel.steh...@gmail.com To: Vikram A vikkiatb

[GENERAL] Help needed with PostgreSQL clustering/switching from MySQL

that there are a number of different OSS solutions for implementing failover and clustering with PostgreSQL, but no official version. Is this understanding correct? If yes, which solution is best suited for running PostgreSQL in a private cloud, with clustering/failover support? Thank you, Vikram THIS EMAIL ANY

Re: [GENERAL] ncoding Table Name and Filed Name

Hi Mr. David, Thanks for the comment. I understood, its more difficult to mange the schema; when schema itself written in jig jack.  Vikram From: David Johnston pol...@yahoo.com To: 'Vikram A' vikkiatb...@yahoo.in Cc: pgsql-general@postgresql.org Sent: Friday

[GENERAL] ncoding Table Name and Filed Name

you Vikram A

Re: [GENERAL] PGP encrypt/decrypt - Prereqistes

on my decision and about the use of PGP functions. Thank you. Vikram A From: Craig Ringer cr...@postnewspapers.com.au To: Vikram A vikkiatb...@yahoo.in Cc: PGSQL - Genearal pgsql-general@postgresql.org Sent: Tuesday, 14 June 2011 12:52 PM Subject: Re: [GENERAL] PGP

Re: [GENERAL] PGP encrypt/decrypt - Prereqistes

. Please give your thoughts on this. Thank you Vikram From: Craig Ringer cr...@postnewspapers.com.au To: Vikram A vikkiatb...@yahoo.in Cc: PGSQL - Genearal pgsql-general@postgresql.org Sent: Tuesday, 14 June 2011 11:00 AM Subject: Re: [GENERAL] PGP encrypt/decrypt

Re: [GENERAL] PGP encrypt/decrypt - Prereqistes

/decryption.   Any other methods/techniques are there for encryption? I prefer encryption with key; key also should not be known to Developers.  Please suggest any such methods.  Thank you in advance. Vikram From: Craig Ringer cr...@postnewspapers.com.au To: Vikram

[GENERAL] PGP encrypt/decrypt - Prereqistes

Hi there, I am new to postgreSQL. I would like to use encrypt/decrypt using PGP keys on windows. May i know, 1. What should i know before i proceed? 2. Any manual to follow the steps ? Thank you in advance Vikram

Re: [GENERAL] Windows 2003 server installation issue

platform except Windows 2003. Thanks Regards, Vikram -Original Message- From: Igor Neyman [mailto:iney...@perceptron.com] Sent: Wednesday, August 18, 2010 6:35 AM To: Vikram Patil; j...@commandprompt.com Cc: pgsql-general@postgresql.org Subject: RE: Windows 2003 server installation issue

Re: [GENERAL] Windows 2003 server installation issue

Hello Sachin, Thanks for reply. I will check that one out. Thanks Regards, Vikram From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] Sent: Tuesday, August 17, 2010 10:48 PM To: Vikram Patil Cc: j...@commandprompt.com; pgsql-general

Re: [GENERAL] Windows 2003 server installation issue

-administrator. I am getting an error code 5 in event viewer when I try to use administrator as service user.Before attempting that I used initdb to create Data directory with same user Thanks Regards, Vikram -Original Message- From: Joshua D. Drake [mailto:j...@commandprompt.com

[GENERAL] Windows 2003 server installation issue

://archives.postgresql.org/pgsql-bugs/2009-10/msg00128.php I get an error as below OpenProcessToken : error code 5 when I start as service but if I start postgresql from command line as pg_ctl start -D Then it starts up. Please provide some input on this. Thanks Regards, Vikram

[GENERAL] File Handling in pgsql

Hi, I would like to store the files(.doc, .xls , images, vedios) in the postgresql data base as a field. Is postgres is supporting such kind of activities? Or In what way i can do so? Please guide me. Thank you in advance, Vikram A

Re: [GENERAL] File Handling in pgsql

edition[5.x]. And if it is bytea - the backup operation is only once, it is not needed to take the files along with DB backup. Thank you very much for the suggestions. Vikram A From: Craig Ringer cr...@postnewspapers.com.au To: Vikram A vikkiatb...@yahoo.in Cc

[GENERAL] Floating point exception in initdb

exception instead of division by zero on some platforms (Tom) http://www.postgresql.org/docs/8.4/static/release-8-4-1.html I am not able to located description about this bug. Please also let me know where I can look at this bug description Thanks Regards, Vikram

Re: [GENERAL] Floating point exception in initdb

and now trying to step through for finding failure location. Thanks Regards, Vikram -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, March 29, 2010 4:45 PM To: Vikram Patil Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Floating point exception

Re: [GENERAL] Floating point exception in initdb

Tom, Thanks for guidelines. I checked glibc versions. I am currently using glibc libarary 2.3.3 on SUSE platform while build machine I used has glibc library 2.5 . I will try to install it on SUSE machine with glibc library 2.5. Thanks Regards, Vikram -Original Message- From: Tom

Re: [GENERAL] AIX postgresql error

Thanks Laurence for Reply. I can actually connect to server using network. I am just trying to avoid this warning. Your solution for listen_address will work but I want to keep it as * . Somehow it doesn't complain on any other *nix Operation Systems. Thanks Regards, Vikram -Original

[GENERAL] AIX postgresql error

please provide some input to avoid this warning / error ? Though its not harmful but its misleading Thanks Regards, Vikram

Re: [GENERAL] PostgreSQL on Windows Server 2003 for Moodle

Trevor , If you have just a need to install and use Windows Server 2003 , you can do that one easily . Just install it go to data directory modify conf files Vikram On Sep 14, 5:43 pm, trevor.john...@tafensw.edu.au (Johnson, Trevor) wrote: Hi I'm new to PostgreSQL and I'm looking

Re: [GENERAL] Regarding initdb pg_ctl

of these problems are caused only on Windows 2003 Server Enterprise Edition with windows XP everything is fine. Can you provide some inputs on this? Thanks Regards, Vikram -Original Message- From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Tuesday, September 15, 2009 1:19 AM To: Vikram

Re: [GENERAL] Regarding initdb pg_ctl

that there are no failures. So we can assume it is a issue with permissions. Thanks Regards Vikram -Original Message- From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Monday, September 14, 2009 4:28 AM To: Vikram Patil Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Regarding initdb

[GENERAL] Issue regarding permissions on Windows 2003 server

on this. Thanks Regards, Vikram

[GENERAL] Regarding initdb pg_ctl

: could not locate matching postgres executable , .\src\backend\postmaster\postmaster.c:1070 ... Please provide some inputs how to tackle with this permission issues. Thanks in advance Thanks Regards, Vikram

[GENERAL] Creating Superuser and password

file. But this approach seems insecure as password has to be in clear in the file. So is there any other way so that I can store password for super user before starting up server through installer. Thanks Regards, Vikram

[GENERAL] Regarding installing starting Postgres on Windows

in FAQs that I can start database server by revoking administrative rights. But how I can do that is not mentioned there. Basically I am trying to create similar experience like installer . Please provide some idea on this issue. Thank you very much in advance . Regards, Vikram

[GENERAL] Compiling using Visual Studio 2005

-ossp.c(27): fatal error C1083: Cannot open include file: 'uuid.h': No such file or directory config.pl : uuid='C:\pgsqlsrcreqs\uuid', #--with-ossp-uuid Thanks Regards, Vikram

[GENERAL] Regarding visual studio 2008 build

, Vikram

[GENERAL] Compiler versions on different platforms

of these binaries and looking to achieve performance of these binary as close as possible to binaries provided at PostgreSQL website. Or if somebody can point out which binaries EnterpriseDB uses for their binaries it will be great. Thanks Regards, Vikram

[GENERAL] Thank you

My friend started a small e-learning company and asked me to develop the IT solution. The company is now 5 years old and postgresql has been in use for the last 4 years. In the past 4 years NOT ONCE has postgresql crashed on us. We have had times when the server utilization was at 100% and swap

Re: [GENERAL] postgres in freebsd jail

jail.sysvipc_allowed sysctl for kernel? I haven't run Postgresql in jail myself but as far as I know the sysctl above is needed in order to use sysv IPC and shared memory functionality inside the jail. -Reko Yes, It worked on setting sysvipc_allowed to 1. Thanks, Vikram