[GENERAL] Block Corruption issue..

2015-05-08 Thread Sachin Srivastava
; Regards, Sachin Srivastava DISCLAIMER: This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any

[GENERAL] template_postgis issue

2015-05-15 Thread Sachin Srivastava
Dear Concern, When I am installing PostgreSQL version 9.1 with PostGIS 1.5 then it's creating "template_postgis" database by default. But when I am installing below PostgreSQL version 9.3 with PostGIS 2.1.7 postgresql-9.3.6-2-windows-x64 postgis-bundle-pg93x64-setup-2.1.7-1 And PostgreSQL versi

[GENERAL]

2015-05-15 Thread Sachin Srivastava
* Regards, *Sachin Srivastava* Assistant Technical Lead(Oracle/PostgreSQL)| TSG *Cyient* | www.cyient.com

Re: [GENERAL]

2015-05-18 Thread Sachin Srivastava
at 5:16 PM, Sachin Srivastava wrote: > Hi, > > > > How can I fast my daily pg_dump backup. Can I use parallel option(Which is > introduced in Postgres 9.3) with Postgres 9.1. There is any way I can use > this is for 9.1 database. > > > > > > My database size i

[GENERAL] pg_xlog Concern

2015-05-18 Thread Sachin Srivastava
something in my postgresql.conf and somewhere else. *Note:* On daily basis Production team is entering the data in bulk (approx. 30-50 GB) in the database and there are only 2 databases on this server. Regards, *Sachin Srivastava* Assistant Technical Lead(Oracle/PostgreSQL)| TSG

[GENERAL] Memory Utilization Issue

2015-05-20 Thread Sachin Srivastava
file | 4096 wal_level | configuration file | archive work_mem | configuration file | 32768 log_timezone | environment variable | Asia/Kolkata max_stack_depth| environment variable | 2048 TimeZone | environm

[GENERAL] Getting error "IST FATAL: the database system is in recovery mode"

2015-07-17 Thread Sachin Srivastava
Dear Team, I am getting the below error in my database pg_log file and also I am unable to open the database. "IST FATAL: the database system is in recovery mode" I am using postgresql version 9.1 on Centos 6.6. Kindly suggest why this problem is coming. Regards, Sachin

[GENERAL] How to restore

2015-08-09 Thread Sachin Srivastava
Dear Team, If I have taken any backup successfully through pg_dump? How can I restore this pg_dump(Sql file) without use of pg_restore. There is any command line option or through psql, kindly inform to me. Regards, Sachin

Re: [GENERAL] PostgreSQL - The Best Overall Database

2015-08-14 Thread Sachin Srivastava
; Microsoft SQL Server<http://www.microsoft.com/> Regards, Sachin Srivastava Consultant (Oracle/PostgreSQL) | Technical Support Group | DNO – T & N Tom Tom Cyient | www.cyient.com<http://www.cyient.com/> Mobile: +91 981 114 9139 | sachin.srivast...@cyient.com<mailto:sachin.

[GENERAL] How to tune my new server

2015-08-18 Thread Sachin Srivastava
Hi, If my system RAM is 50 GB then how can I tune my database server without using the Thumb rule of postgresql.conf parameter like: Shared_buffer: 25% of the RAM temp_buffers: should be default work_mem: AvRAM/2 * Max_connections etc... There is any another way or any other rule or Tool which c

[GENERAL] pg_basebackup problem for Streaming replication

2015-09-02 Thread Sachin Srivastava
Dear Experts, One problem, I am facing that when I am using *pg_basebackup* (on Standby Server) it’s copying only some files and directories not all like pg_notify folder etc. That’s why when I am restarting the database on "Standby Server" after "pg_basebackup" then it’s showing an error below.

Re: [GENERAL] pg_basebackup problem for Streaming replication

2015-09-09 Thread Sachin Srivastava
Dear All, Kindly suggest to me why this problem is coming. Regards, Sachin On Thu, Sep 3, 2015 at 12:09 PM, Sachin Srivastava wrote: > Dear Experts, > > > One problem, I am facing that when I am using *pg_basebackup* (on Standby > Server) it’s copying only some files and dire

[GENERAL] How to reduce pg_dump backup time

2015-10-05 Thread Sachin Srivastava
on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit (1 row) postgres=# *Regards,* Sachin Srivastava

[GENERAL] How SQL SELECT * statement works in Postgres?

2016-06-05 Thread Sachin Srivastava
Dear Team, Kindly inform to me How PostgreSQL Processes SQL Statements internally? How SQL SELECT * statement works in Postgres? Regards, SSR

[GENERAL] DB_link connection

2015-11-16 Thread Sachin Srivastava
Hi, Any one can help me how we can install "dblink_connect" in PostgreSQL9.4 on linux platform. If Possible, please provide the steps. Regards, Sachin Srivastava 9811149139

[GENERAL] SQL conversion tool

2015-11-18 Thread Sachin Srivastava
Hi, Please inform which is the best tool for SQL conversion because I have to migration Oracle database into PostgreSQL. Regards, SS

[GENERAL] Postgresql Dump Question

2015-11-26 Thread Sachin Srivastava
Hi Team, If anybody have PostgreSQL Dump questions like Oracle dump question for preparation of PostgreSQL certification. kindly provide, if someone have. Regards, SS

[GENERAL] Function in PostgreSQL

2015-12-09 Thread Sachin Srivastava
Hi, Do you know if it is possible to create a function in postgres that has errors in the syntax of the creation sql? It would help our conversion process if we could get all of our various functions present in postgres even if they aren’t in 100% working shape. Is there any way to ignore errors

[GENERAL] RAM of Postgres Server

2016-01-06 Thread Sachin Srivastava
Dear Team, Please suggest, how much RAM and core should be define for New Postgres database server, if we will use Postgres 9.3 and above. If suppose my postgres database size will be near about 300 to 500 GB for future. There is any document regarding this server configuration, suggest ? Regar

Re: [GENERAL] RAM of Postgres Server

2016-01-06 Thread Sachin Srivastava
ce, please clarify the benefit of more core to me. Right now we have 1 core for first database server and 2 core for another database server. Regards, Sachin On Thu, Jan 7, 2016 at 11:25 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jan 6, 2016 at 10:39 PM

Re: [GENERAL] RAM of Postgres Server

2016-01-07 Thread Sachin Srivastava
databases will have 32 cores of CPU and 128 GB of RAM. If you want any other information then inform to me. Regards, SS On Thu, Jan 7, 2016 at 8:51 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jan 7, 2016 at 12:32 AM, Sachin Srivastava < > ssr.tele

Re: [GENERAL] RAM of Postgres Server

2016-01-07 Thread Sachin Srivastava
Dear John, We are looking at more like 500-600 connections simultaneously in 1 day and I want to say we get 1 to 12000 connections a day per db. Regards SS On Fri, Jan 8, 2016 at 10:49 AM, John R Pierce wrote: > On 1/7/2016 8:21 PM, Sachin Srivastava wrote: > > *Q. Total Connect

[GENERAL] Function error

2016-01-07 Thread Sachin Srivastava
Dear Concern, I am creating below function *“create_catexp_ss_master()” *and getting error as below, I have already created dependent function firstly successfully *(“create_catexp_ss_1” and “create_catexp_ss_2”) *but still getting error, please suggest why? ERROR: syntax error at or near "c

Re: [GENERAL] Function error

2016-01-07 Thread Sachin Srivastava
Thanks Pavel !!! On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule wrote: > Hi > > > > 2016-01-08 8:24 GMT+01:00 Sachin Srivastava : > >> Dear Concern, >> >> >> >> I am creating below function *“create_catexp_ss_master()” *and getting >> err

Re: [GENERAL] Function error

2016-01-07 Thread Sachin Srivastava
Thanks Charles !!! On Fri, Jan 8, 2016 at 1:15 PM, Sachin Srivastava wrote: > Thanks Pavel !!! > > On Fri, Jan 8, 2016 at 1:05 PM, Pavel Stehule > wrote: > >> Hi >> >> >> >> 2016-01-08 8:24 GMT+01:00 Sachin Srivastava : >> >>>

Re: [GENERAL] Function error

2016-01-08 Thread Sachin Srivastava
Hi, Also there is any command to see the invalid and valid function in postgres database. Regards, SS On Fri, Jan 8, 2016 at 1:18 PM, Sachin Srivastava wrote: > Thanks Charles !!! > > On Fri, Jan 8, 2016 at 1:15 PM, Sachin Srivastava > wrote: > >> Thanks Pavel !!! >

Re: [GENERAL] Function error

2016-01-08 Thread Sachin Srivastava
Hi, I am also getting "syntax error for below function (just some lines of function where I am getting syntax error), please suggest why? -- Image path AND mk1.subscriber_id(+)=pcat_catalog_item.subscriber_id AND cs1.subscriber_id(+)=pcat_catalog_item.subscr

Re: [GENERAL] Function error

2016-01-08 Thread Sachin Srivastava
Because I have migrated the database from Oracle to Postgres through ORA2PG. So how I will change it, please suggest. On Fri, Jan 8, 2016 at 2:54 PM, Pavel Stehule wrote: > > > 2016-01-08 10:08 GMT+01:00 Sachin Srivastava : > >> Hi, >> >> I am also getting &q

Re: [GENERAL] Function error

2016-01-08 Thread Sachin Srivastava
Thanks Pavel for your help !!! On Fri, Jan 8, 2016 at 3:28 PM, Pavel Stehule wrote: > > > 2016-01-08 10:52 GMT+01:00 Sachin Srivastava : > >> Because I have migrated the database from Oracle to Postgres through >> ORA2PG. >> >> So how I will chan

[GENERAL] Giving error for function

2016-01-11 Thread Sachin Srivastava
Hi, I am getting the below error while I am running the below function "add_po_doc_hist", for "c_company" cursor, please suggest what is wrong with code. ERROR: relation "c_company" does not exist CONTEXT: compilation of PL/pgSQL function "add_po_doc_hist" near line 11 ** Error

[GENERAL] Function error

2016-01-13 Thread Sachin Srivastava
Dear Team, I am getting the below error for function, please see the bold line in "Function code", please suggest what I will do to correct this code. --- ERROR: syntax error at or near "*" LINE 35: SELECT * from logError(msg text) is ^ CONTEXT: invalid typ

Re: [GENERAL] Function error

2016-01-13 Thread Sachin Srivastava
it's not running. Regards, Sachin On Thu, Jan 14, 2016 at 12:37 AM, Adrian Klaver wrote: > On 01/13/2016 01:18 AM, Sachin Srivastava wrote: > > > > Dear Team, > > > > I am getting the below error for function, please see the bold line in > > "

[GENERAL] Error in Update and Set statement

2016-01-20 Thread Sachin Srivastava
Dear Folks, How to handle the below error, please suggest. I have migrated my database from oracle to postgres through Ora2PG then I am getting this error for function. If I am writing the code for every column which are within set (column name1, column name2, etc) then it's running successfully

Re: [GENERAL] Error in Update and Set statement

2016-01-20 Thread Sachin Srivastava
Boss !! I am using postgres 9.4, so how to handle this. On Wed, Jan 20, 2016 at 4:11 PM, Pavel Stehule wrote: > Hi > > 2016-01-20 11:36 GMT+01:00 Sachin Srivastava : > >> Dear Folks, >> >> How to handle the below error, please suggest. I have migrated my >&

[GENERAL] ERROR for '@' for function

2016-01-20 Thread Sachin Srivastava
How to handle this below situation, I am getting error for function, my Postgres version is 9.4 is ERROR: syntax error at or near "@" LINE 67: autonumbersett...@repos.birchstreet.net ^ ** Error ** ERROR: syntax error at or near "@" SQL state: 42601 C

Re: [GENERAL] ERROR for '@' for function

2016-01-20 Thread Sachin Srivastava
Thanks Thomas !!! Now, it's working fine. On Wed, Jan 20, 2016 at 5:18 PM, Thomas Kellerer wrote: > Sachin Srivastava schrieb am 20.01.2016 um 12:42: > > How to handle this below situation, I am getting error for function, my > Postgres version is 9.4 > > is > > &

[GENERAL] Syntax error for Function

2016-01-20 Thread Sachin Srivastava
I am unable to find out the syntax error in below code, please suggest? ERROR: syntax error at or near "select" LINE 44: select Count(0) into sFound from budget_period ... ^ ** Error ** ERROR: syntax error at or near "select" SQL state: 42601 Ch

Re: [GENERAL] Syntax error for Function

2016-01-20 Thread Sachin Srivastava
SECURITY DEFINER COST 100; ALTER FUNCTION gen_budget_for_next_year(bigint, bigint, bigint) OWNER TO postgres; -------- On Wed, Jan 20, 2016 at 6:05 PM, Thom Brown wrote: > On 20 January 2016 at 12:15, Sachin Srivastava > wrote: > > I am unable to find out the syntax

Re: [GENERAL] Syntax error for Function

2016-01-20 Thread Sachin Srivastava
end and first I am getting the error for this line. I am the new one for plsql code that's why I am taking the expert advice. Thanks SS On Wed, Jan 20, 2016 at 8:30 PM, Adrian Klaver wrote: > On 01/20/2016 06:32 AM, Sachin Srivastava wrote: > >> Dear Thom, >> >> P

[GENERAL] Variable not found

2016-01-20 Thread Sachin Srivastava
Dear Folks, I have a question about global variables in Oracle pl/sql package. Where are these variables when package is converted to schema from Oracle to Postgres through Ora2PG Tool? For example, package

Re: [GENERAL] Variable not found

2016-01-21 Thread Sachin Srivastava
Dear Adrian, So, how the effective way to search this because I have around 1300 tables. Regards, SS On Thu, Jan 21, 2016 at 8:48 PM, Adrian Klaver wrote: > On 01/20/2016 07:35 PM, Sachin Srivastava wrote: > >> Dear Folks, >> >> I have a question about global va

[GENERAL] Postgres 9.4.5 Installation on Centos 7.3

2016-01-28 Thread Sachin Srivastava
Hi, I have to install Postgres 9.4.5 On Centos 7.2, what is the best way to install, please suggest: Through ./configure and make OR Through below link: https://wiki.postgresql.org/wiki/YUM_Installation#Configure_your_YUM_repository Please provide, if any other installation document. For

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

2016-01-28 Thread Sachin Srivastava
drwx-- 2 postgres postgres 4096 Jan 29 11:39 pg_notify drwx-- 2 postgres postgres 4096 Jan 29 11:39 global drwx-- 5 postgres postgres 4096 Jan 29 11:39 base [root@gdi-test postgres9.4]# --- Regards SS On Fri, Jan 29, 2016 at 11:33 AM, A

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

2016-01-28 Thread Sachin Srivastava
i, Jan 29, 2016 at 12:34 PM, John R Pierce wrote: > On 1/28/2016 10:24 PM, Sachin Srivastava wrote: > >> I have initialized the database through below command through Postgres >> user but in my "/u01/postgres9.4/" folder pg

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

2016-01-28 Thread Sachin Srivastava
Here selinux is already disabled on server and I am installing postgres on Centos 7.2. On Fri, Jan 29, 2016 at 1:12 PM, John R Pierce wrote: > On 1/28/2016 11:21 PM, Sachin Srivastava wrote: > >> >> Is it not possible If my storage is mounted on /u01 and I will create the &g

[GENERAL] Multi Master Replication setup

2016-03-28 Thread Sachin Srivastava
Dear Concern, Kindly inform to me how to setup multi master replication in Postgres. Kindly provide the link of step by step setup of this or any video or setup document regarding this. Regards Sachin

Re: [GENERAL] Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

2010-11-07 Thread Sachin Srivastava
SQL? Can you attach the installation log (%TEMP%\install-postgresql.log) or (%TEMP%\bitrock_installer_.log). > > > > -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

2010-11-09 Thread Sachin Srivastava
ral-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] *On Behalf Of *Sachin Srivastava > *Sent:* den 8 november 2010 08:56 > > *To:* Anders Söderman > *Cc:* pgsql-general@postgresql.org > *Subject:* Re: [GENERAL] Run "postgresql\9.0\data" on a RAID-1 disk on my

Re: [GENERAL] Help with Stack Builder

2010-11-12 Thread Sachin Srivastava
t; To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] How to install in windows 2000

2010-11-18 Thread Sachin Srivastava
us. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Installation Issue of PostgresPlus-9.0

2011-02-02 Thread Sachin Srivastava
ify the correct timezone in >> postgresql.conf. >> >> >> >> >> >> Thanks & Regards >> Adarsh Sharma >> > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] plperl.dll on windows with postgresql 9.0

2011-02-06 Thread Sachin Srivastava
that I need to install similar to Unix? > > Thanks. > -- > Robert > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

2011-02-13 Thread Sachin Srivastava
n > http://www.contactking.de > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

Re: [GENERAL] Upgrading to 9.0 on Mac OS X

2011-02-13 Thread Sachin Srivastava
postgres' but database superuser 'postgres'. > > Make it a good password (long, use digits etc. to avoid being simply > dictionary words). > > When you run the 'pgAdmin' app, it will prompt you for that 'postgres' > password to connect to the d

Re: [GENERAL] password

2011-02-20 Thread Sachin Srivastava
e, you will have > even more code to adjust based on the faulty design. > . > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company.

[GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
Dear Expert, My PostgreSQL database got down due to no space left on my mount point /dev/vdb1 where my data directory are available, please suggest what's the best solution to resolve this issue. I am also not able to start my database again due to no space available. And right now, we don't have

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
./base 0 ./pg_replslot 0 ./pg_tblspc 0 ./pg_stat 216K./pg_stat_tmp 0 ./pg_logical/snapshots 0 ./pg_logical/mappings 0 ./pg_logical 897M./pg_log 100G. -bash-4.2$ Regards, Sachin Srivastava Mb.: 9811149139 On Sun, Feb 19, 2017 at 11:29 AM, Alvaro Aguayo

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
With correction: pg_log consumed 897 MB only Regards, Sachin Srivastava Mb.: 9811149139 On Sun, Feb 19, 2017 at 11:32 AM, Sachin Srivastava wrote: > I have checked pg_log only 890 GB space consumed and pg_log folder > consumed 1.1 GB only. All the space consumed by the database fil

Re: [GENERAL] No space left on device

2017-02-18 Thread Sachin Srivastava
Thanks Alvaro for your suggestion !! Regards, Sachin Srivastava Mb.: 9811149139 On Sun, Feb 19, 2017 at 11:40 AM, Alvaro Aguayo Garcia-Rada < aagu...@opensysperu.com> wrote: > Cleaning pg_log should be enough to be able to start your postgres > instance. However, it will let you

[GENERAL] Error in PostgreSQL Log

2017-04-28 Thread Sachin Srivastava
Dear Team, Please suggest why we are getting the below error in our PostgreSQL DB log. We are using postgresql version = 9.2 ERROR: prepared transaction with identifier "131077_AP//CqqfIep65ipZAmdpAAIcgjE=_AP//CqqfIep65ipZAmdpAAIciwAA" does not exist STATEMENT:

Re: [GENERAL] Error in PostgreSQL Log

2017-04-28 Thread Sachin Srivastava
I have already tuned below parameters as max_prepared_transactions = 500 max_connection = 2000 Regards, SSR On Sat, Apr 29, 2017 at 12:15 AM, Sachin Srivastava wrote: > Dear Team, > > Please suggest why we are getting the below error in our PostgreSQL DB log. > > We are u

Re: [GENERAL] Documentation - PgAdmin

2009-07-05 Thread Sachin Srivastava
iner. Regards, Chris -- Regards, Sachin Srivastava www.enterprisedb.com

[GENERAL] initdb failure on Windows XP

2009-07-17 Thread Sachin Srivastava
oking into the initdb code, it should create sub directories (global, pg_xlog, pg_clog, base etc ) under directory C:/postgres/data. I cannot understand, why it is trying to create "C:/postgres". Any thoughts? -- Regards, Sachin Srivastava www.enterprisedb.com -- Sent via p

Re: [GENERAL] initdb failure on Windows XP

2009-07-17 Thread Sachin Srivastava
On 07/18/2009 12:03 AM, Joshua D. Drake wrote: On Fri, 2009-07-17 at 23:42 +0530, Sachin Srivastava wrote: I am using PostgreSQL 8.3 on Windows XP SP2. I am getting this strange error while initdb: Part of the error message i get, The database cluster will be initialized with locale

Re: [GENERAL] uuid-ossp for PostGres 8.4 running on Windows

2009-07-18 Thread Sachin Srivastava
main concern now is to get the uuid-ossp install for 8.4 so that I can use 8.4 for our new development. Best Regards Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

Re: [GENERAL] How do I run PG Tuning Wizard on Linux?

2009-07-29 Thread Sachin Srivastava
On 07/29/2009 09:46 PM, Jennifer Trey wrote: Is this it? http://pgfoundry.org/projects/pgtune I thought it was EnterpriseDB. Perhaps that's only for windows? Thanks / Jen You can have TuningWizard (EnterpriseDB's) for linux also available through StackBuilder. -- Regards, Sachin

Re: [GENERAL] How do I run PG Tuning Wizard on Linux?

2009-07-30 Thread Sachin Srivastava
ill see a bunch of applications you can choose to install. TuningWizard is one of them. -- Regards, Sachin Srivastava www.enterprisedb.com -- 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] How do I run PG Tuning Wizard on Linux?

2009-07-30 Thread Sachin Srivastava
/lib/dpkg/info/libexpat1.postrm /var/lib/dpkg/info/libexpat1.shlibs Any ideas? -- Regards, Sachin Srivastava www.enterprisedb.com

Re: [GENERAL] pg_config --sharedir points to the wrong folder.. is this a problem?

2009-07-30 Thread Sachin Srivastava
environment variable to have one-click installers pg_config being used in global scope. (Make sure you remove the apt-gets installation correctly) -- Regards, Sachin Srivastava www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] How do I run PG Tuning Wizard on Linux?

2009-07-30 Thread Sachin Srivastava
ght, do I need the Apache Server thingy that one can select on the StackBuilder? No not for running TuningWizard atleast. I am running on Ubuntu Server 9.04 Thanks / Jen -- Regards, Sachin Srivastava www.enterprisedb.com

Re: [GENERAL] 2 versions of Postgres on the same machine

2009-08-18 Thread Sachin Srivastava
using yum, and compile the other please. Or use EnterpriseDB's one-click installer for PostgreSQL 8.3 and PostgreSQL 8.4, you will have 2 parallel version of server running simultaneously without needing to compile from source. -- Regards, Sachin Srivastava www.enterprisedb.com

Re: [GENERAL] Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

2009-08-31 Thread Sachin Srivastava
Hello, -- hostall all 10.0.0.6 md5 You have to add mask to the ip. like, hostall all 10.0.0.6/32 md5 -- Regards, Sachin Srivastava www.enterprisedb.com

Re: [GENERAL] install postgis in linux server without desktop

2009-09-02 Thread Sachin Srivastava
/tmp by default). Then use the binary with "--mode text" as an option. Check --help for all options available. -- Regards, Sachin Srivastava www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] error message on install [ REPOST from pgsql-novice ]

2009-10-01 Thread Sachin Srivastava
/install-postgresql.log). You can also post the error part of the log. what have I missed please? Greg -- Regards, Sachin Srivastava www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[GENERAL] initdb failing

2009-10-06 Thread Sachin Srivastava
g/data" not removed at user's request Anything that i am missing anywhere??// / -- Regards, Sachin Srivastava www.enterprisedb.com

Re: [GENERAL] initdb failing

2009-10-06 Thread Sachin Srivastava
On 10/06/2009 11:41 PM, Raymond O'Donnell wrote: On 06/10/2009 19:00, Sachin Srivastava wrote: fixing permissions on existing directory d:/base/netscope/pg/data ... ok * creating subdirectories ... initdb: could not create directory "d:/base/netscope/pg": File exist

Re: [GENERAL] initdb failing

2009-10-06 Thread Sachin Srivastava
On 10/07/2009 01:24 AM, Scott Mead wrote: On Tue, Oct 6, 2009 at 3:09 PM, Sachin Srivastava <mailto:sachin.srivast...@enterprisedb.com>> wrote: On 10/06/2009 11:41 PM, Raymond O'Donnell wrote: On 06/10/2009 19:00, Sachin Srivastava wrote: fixing

Re: [GENERAL] Postgres 9.2 beta2 one-click installer on windows

2012-06-12 Thread Sachin Srivastava
[CCed the list] On Tue, Jun 12, 2012 at 12:33 PM, Sachin Srivastava < sachin.srivast...@enterprisedb.com> wrote: > > On Tue, Jun 12, 2012 at 12:31 PM, Craig Ringer wrote: > >> On 06/11/2012 08:36 PM, Marc Watson wrote: >> >>> >>> *De

Re: [GENERAL] question about installation

2012-07-12 Thread Sachin Srivastava
postgresql on > the 2nd computer, so that both computers share their data in the same > folder.. > I used postgresql 8.4 > The installer will not over-write any settings in your data folder and continue as usual. Its an option where you can give a pre-existing data folder to a new i

Re: [GENERAL] installation problem with postgres password

2012-07-12 Thread Sachin Srivastava
hange-password-windows-7.htm > > > > Thanks & Regards, > > > > Raghu Ram > > > > EnterpriseDB Corporation > > > > Blog:http://raghurc.blogspot.in/ > > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Regards, Sachin Srivastava EnterpriseDB, India

Re: [GENERAL] installation problem with postgres password

2012-07-17 Thread Sachin Srivastava
ed does not meet the local or domain policy. > > Check the minimum length, password complexity and password history > > requirements." > > > > My question > > 1) Have you installed any other program successfully on this machine? > > > > > > -- > > Adrian Klaver > > adrian.kla...@gmail.com > > > > > -- Regards, Sachin Srivastava EnterpriseDB, India

Re: [GENERAL] Cannot Run EnterpriseDB Postgresql Installation

2012-08-23 Thread Sachin Srivastava
sue. There are also no logs anywhere. Please help, as my development > is fully stranded because of this issue. > -- Regards, Sachin Srivastava EnterpriseDB, India

Re: [GENERAL] how long to wait on 9.2 bitrock installer?

2012-09-12 Thread Sachin Srivastava
has 2048 MB (serial number 83631A87) > > Slot 'DIMM 5 ' has 2048 MB (serial number 83631A85) > > Slot 'DIMM 6 ' has 2048 MB (serial number 83631A83) > > Local Drive Volumes new – volume encryption > > > > > > c: (NTFS on drive 0) 1000.21 GB 210.02 GB free > > > Network Drives > > ** ** > -- Regards, Sachin Srivastava EnterpriseDB, India <>

Re: [GENERAL] how long to wait on 9.2 bitrock installer?

2012-09-12 Thread Sachin Srivastava
y, September 12, 2012 10:50 PM > *To:* 'Sachin Srivastava' > *Cc:* pgsql-general@postgresql.org > *Subject:* RE: [GENERAL] how long to wait on 9.2 bitrock installer? > > ** ** > > C:\Users\dcorbit\AppData\Local\Temp>dir /s install-postgresql.log > > Vo

Re: [GENERAL] can't install postgres 8.4 on windows 2003 server

2010-05-24 Thread Sachin Srivastava
taller_1004serverlog.log There must be a log file with name install-postgresql.log in the %TEMP% directory. -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

Re: [GENERAL] uppdate from postgersql 8.3.7 to 8.4.4

2010-05-25 Thread Sachin Srivastava
a solution for this? Kind regards, Paul -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

Re: [GENERAL] can't install postgres 8.4 on windows 2003 server

2010-05-25 Thread Sachin Srivastava
: pg_ctl: could not register service "postgresql-8.4": error code 0 The postgres service is not listed under services. Thanks. http://old.nabble.com/file/p28660078/install-postgresql.log install-postgresql.log Sachin Srivastava-2 wrote: On 5/24/10 7:52 PM, ritas wrote: Hi,

Re: [GENERAL] Silent installer in Windows

2010-06-14 Thread Sachin Srivastava
Ps I read pginstaller doc about silent installing <http://pginstaller.projects.postgresql.org/silent.html> but I noticed that pginstaller no longer available as mentioned in its home page. -- Best Regards Muhammad Bashir Al-Noimi My Blog:http://mbnoimi.net -- Regards, S

Re: [GENERAL] Unable to install pg in Win (MVR error)

2010-06-14 Thread Sachin Srivastava
the installer I noticed that pg services didn't start at all although I successfully installed pg on another PC! -- Best Regards Muhammad Bashir Al-Noimi My Blog: http://mbnoimi.net -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] Silent installer in Windows

2010-06-15 Thread Sachin Srivastava
--servicepassword root --unattendedmodeui minimal --mode unattended --prefix c:\pg-8.4 --datadir c:\pgData --superpassword admin On Mon, Jun 14, 2010 at 9:55 PM, Sachin Srivastava <mailto:sachin.srivast...@enterprisedb.com>> wrote: In the One-Click Installer for PostgreSQL use the C

Re: [GENERAL] postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in

2010-07-28 Thread Sachin Srivastava
the latest enterprisedb standard server is only 8.4.1 (New! 13-Oct-09) :-) By using the StackBuilder Plus application, you can upgrade your server to 8.4.4. -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterpr

Re: [GENERAL] Windows 2003 server installation issue

2010-08-17 Thread Sachin Srivastava
ied patch from following thread to 8.4.1 source code and it seems to be working with every windows operating system except Windows 2003 . There is a reason the community provides binary packages. The idea that you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4. Sincerely, Joshua D.

Re: [GENERAL] Slony-I installation Help

2010-09-27 Thread Sachin Srivastava
ecause no cluster is created at all. > Please provide the address from which a Complete Installation package for > Slony-I, compatible with the PostgreSQL 8.4 will be available. > Please note that I am using Windows XP. > > > > Thanks & Regards, > Vishnu S > -

Re: [GENERAL] Slony-I installation Help

2010-09-27 Thread Sachin Srivastava
e”. Is this path is correct? > > > > Thanks & Regards, > Vishnu S > > From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] > Sent: Monday, September 27, 2010 7:47 PM > To: Vishnu S. > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERA

Re: [GENERAL] Slony-I installation Help

2010-09-28 Thread Sachin Srivastava
t; > > > Thanks & Regards, > Vishnu S > > From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] > Sent: Tuesday, September 28, 2010 11:15 AM > To: Vishnu S. > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Slony-I installation Help

Re: [GENERAL] PostgreSQL server not starting.

2010-09-30 Thread Sachin Srivastava
> > > Thanks & Regards, > Vishnu S > -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise Postgres company.

Re: [GENERAL] PostgreSQL server not starting.

2010-09-30 Thread Sachin Srivastava
ation log file. > I have used Uninstaller to uninstall the PostgreSQL and then the data > directory is removed manually. > > > > > Thanks & Regards, > Vishnu S > > From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com] > Sent: Thursday, S

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

2009-11-28 Thread Sachin Srivastava
be sure(no logs) but VMWare Workstation seems to have been affected here too, can't get it to work anymore. Other people having the same problem: http://ubuntuforums.org/showthread.php?t=1307864 https://bugs.launchpad.net/ubuntu/+bug/461105 Best regards, Leonardo C. -- R

Re: [GENERAL] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

2009-11-29 Thread Sachin Srivastava
tep 1 is probably to rebuild the installer using libraries where everything has been given custom soversions; next step is to use rpath linkage to solve the problem properly. -- Craig Ringe -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres &l

Re: [GENERAL] how to install just client libraries on windows?

2009-12-01 Thread Sachin Srivastava
n a process of verifying the changes and will be hoping to release it very soon. -- Craig Ringer -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

  1   2   >