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

2009-09-18 Thread vikram
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 Po

Re: [GENERAL] postgres in freebsd jail

2004-08-16 Thread Vikram
-Reko Yes, It worked on setting sysvipc_allowed to 1. Thanks, Vikram ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Compiling using Visual Studio 2005

2009-07-07 Thread Vikram Patil
-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 installing & starting Postgres on Windows

2009-08-20 Thread Vikram Patil
read 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] Creating Superuser and password

2009-09-04 Thread Vikram Patil
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] Issue regarding permissions on Windows 2003 server

2009-09-11 Thread Vikram Patil
this. Thanks & Regards, Vikram

[GENERAL] Regarding initdb & pg_ctl

2009-09-11 Thread Vikram Patil
s.exe: 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

Re: [GENERAL] Regarding initdb & pg_ctl

2009-09-14 Thread Vikram Patil
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 in

Re: [GENERAL] Regarding initdb & pg_ctl

2009-09-16 Thread Vikram Patil
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 Patil Cc: p

[GENERAL] PGP encrypt/decrypt - Prereqistes

2011-06-10 Thread Vikram A
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] PGP encrypt/decrypt - Prereqistes

2011-06-13 Thread Vikram A
/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 To: Vikram A Cc: PGSQL - Gene

Re: [GENERAL] PGP encrypt/decrypt - Prereqistes

2011-06-13 Thread Vikram A
so once it used. Please give your thoughts on this. Thank you Vikram From: Craig Ringer To: Vikram A Cc: PGSQL - Genearal Sent: Tuesday, 14 June 2011 11:00 AM Subject: Re: [GENERAL] PGP encrypt/decrypt - Prereqistes On 14/06/11 11:51, Vikram A wrote: > D

Re: [GENERAL] PGP encrypt/decrypt - Prereqistes

2011-06-15 Thread Vikram A
my decision and about the use of PGP functions. Thank you. Vikram A From: Craig Ringer To: Vikram A Cc: PGSQL - Genearal Sent: Tuesday, 14 June 2011 12:52 PM Subject: Re: [GENERAL] PGP encrypt/decrypt - Prereqistes On 14/06/11 14:29, Vikram A wrote: >

[GENERAL] ncoding "Table Name" and "Filed Name"

2011-06-16 Thread Vikram A
dea. Thank you Vikram A

Re: [GENERAL] ncoding "Table Name" and "Filed Name"

2011-06-18 Thread Vikram A
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 To: 'Vikram A' Cc: pgsql-general@postgresql.org Sent: Friday, 17 June 2011 7:00 PM S

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

2011-06-20 Thread Vikram Vaswani
ual and some sites, it seems 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 clus

[GENERAL] Type casting text to Numeric - Query Error

2011-08-17 Thread Vikram A
t can be ZERO while querying. I need answer as 4055. Can i have your suggestion/solutions please? Regards, Vikram A

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

2011-08-17 Thread Vikram A
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 To: Vikram A Cc: PGSQL - Genearal Sent: Wednesday, 17

[GENERAL] Windows 2003 server installation issue

2010-08-14 Thread Vikram Patil
://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

Re: [GENERAL] Windows 2003 server installation issue

2010-08-17 Thread Vikram Patil
administrator or non-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---

Re: [GENERAL] Windows 2003 server installation issue

2010-08-19 Thread Vikram Patil
dows 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 installati

Re: [GENERAL] Windows 2003 server installation issue

2010-08-19 Thread Vikram Patil
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-gen

[GENERAL] AIX postgresql error

2010-03-18 Thread Vikram Patil
please provide some input to avoid this warning / error ? Though its not harmful but its misleading Thanks & Regards, Vikram

Re: [GENERAL] AIX postgresql error

2010-03-19 Thread Vikram Patil
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, Vi

[GENERAL] Floating point exception in initdb

2010-03-29 Thread Vikram Patil
"floating-point 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

2010-03-29 Thread Vikram Patil
" for configuring 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 poin

Re: [GENERAL] Floating point exception in initdb

2010-03-29 Thread Vikram Patil
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:

[GENERAL] File Handling in pgsql

2010-04-12 Thread Vikram A
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

2010-04-12 Thread Vikram A
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 To: Vikram A Cc: pgsql-general@postgresql.org Sent: Mon, 12

[GENERAL] Compiler versions on different platforms

2009-05-11 Thread Vikram Patil
out performance 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] Regarding visual studio 2008 build

2009-05-20 Thread Vikram Patil
ards, Vikram

[GENERAL] Thank you

2005-01-20 Thread Vikram Singh
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 was