Re: [GENERAL] Error in PostgreSQL Log

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

[GENERAL] Error in PostgreSQL Log

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] No space left on device

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

Re: [GENERAL] No space left on device

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

./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

[GENERAL] No space left on device

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

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

Dear Team, Kindly inform to me How PostgreSQL Processes SQL Statements internally? How SQL SELECT * statement works in Postgres? Regards, SSR

[GENERAL] Multi Master Replication setup

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] Postgres 9.4.5 Installation on Centos 7.3

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

Re: [GENERAL] Postgres 9.4.5 Installation on Centos 7.3

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

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

[GENERAL] Postgres 9.4.5 Installation on Centos 7.3

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] Variable not found

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] Variable not found

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] Syntax error for Function

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

Re: [GENERAL] Syntax error for Function

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

[GENERAL] Syntax error for Function

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] ERROR for '@' for function

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] ERROR for '@' for function

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 in Update and Set statement

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 in Update and Set statement

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] Function error

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] Function error

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

[GENERAL] Giving error for function

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

Re: [GENERAL] Function error

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

Re: [GENERAL] Function error

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

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

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

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

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

[GENERAL] Function error

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] RAM of Postgres Server

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

Re: [GENERAL] RAM of Postgres Server

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

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

[GENERAL] RAM of Postgres Server

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

[GENERAL] Function in PostgreSQL

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] Postgresql Dump Question

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] SQL conversion tool

Hi, Please inform which is the best tool for SQL conversion because I have to migration Oracle database into PostgreSQL. Regards, SS

[GENERAL] DB_link connection

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] How to reduce pg_dump backup time

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

Re: [GENERAL] pg_basebackup problem for Streaming replication

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] pg_basebackup problem for Streaming replication

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.

[GENERAL] How to tune my new server

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

Re: [GENERAL] PostgreSQL - The Best Overall Database

; 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 restore

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

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

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] Memory Utilization Issue

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] pg_xlog Concern

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

Re: [GENERAL]

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]

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

[GENERAL] template_postgis issue

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] Block Corruption issue..

; 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

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

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] how long to wait on 9.2 bitrock installer?

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] Cannot Run EnterpriseDB Postgresql Installation

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] installation problem with postgres password

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] installation problem with postgres password

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] question about installation

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] Postgres 9.2 beta2 one-click installer on windows

[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] Cannot find installers for 9.2 Beta

t; > > -- > 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] Does Stackbuilder need username/pwd for the proxy?

> specify the username and pwd required by the proxy in a special option. > Could this be the case for postGRES too? > Thank you Stackbuilder currently doesn't support authenticated proxies. -- Regards, Sachin Srivastava EnterpriseDB, the Enterprise PostgreSQL company. -- Sent

Re: [GENERAL] Having Issue Getting the Postgresql Service to Start

> stopped.” The user account trying to start the service has administrator > rights on both the server and the Postrgesql folders. Does anyone have any > clues as to why this is happening? Thanks! Anything in the windows event logs? How did you register the service? -- Regards,

Re: [GENERAL] password

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.

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

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] Upgrading to 9.0 on Mac OS X

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] plperl.dll on windows with postgresql 9.0

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] Installation Issue of PostgresPlus-9.0

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] How to install in windows 2000

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] Help with Stack Builder

t; To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- 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)

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] Run "postgresql\9.0\data" on a RAID-1 disk on my Local Area Network (LAN)

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] PostgreSQL server not starting.

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] PostgreSQL server not starting.

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

Re: [GENERAL] Slony-I installation Help

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] Slony-I installation Help

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

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] Windows 2003 server installation issue

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] postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in

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] Silent installer in Windows

--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] Unable to install pg in Win (MVR error)

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

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] can't install postgres 8.4 on windows 2003 server

: 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] uppdate from postgersql 8.3.7 to 8.4.4

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

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] "1-Click" installer problems

tgres'. Default: postgres Or, in fact, must I re-install to change this? It looks like I have to re-install. Thank you very much for responding to my questions. I truly appreciate it. Your support is welcome and superb. John On Apr 2, 2010, at 9:52 AM, Sachin Srivastava wrot

Re: [GENERAL] "1-Click" installer problems

_plpgsql Install pl/pgsql in template1 database? Default: 1 On 4/2/10 1:14 PM, John Gage wrote: There is a CLI option where? Forgive my ignorance, please. Does it appear in the one-click installer? John On Apr 2, 2010, at 9:19 AM, Sachin Srivastava wr

Re: [GENERAL] "1-Click" installer problems

to the database server the commands like psql, pg_dump, etc all use your unix username as the default for the database username, and your username as teh default for the database name, unless you specify a different user and/or database on hte command line. -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

Re: [GENERAL] "1-Click" installer problems

Evangelizing PGSQL was a mistake. Thanks for all your help and good luck to everyone! -n. -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

Re: [GENERAL] Small install (w/ pSQLODBC support) needed.

-- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

Re: [GENERAL] Problems with the Windows 8.4.1 upgrade from 8.3 on non-C drive

upgrade on the C:\ drive. Thanks -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

Re: [GENERAL] how do I disable automatic start on mac os x?

On 01/04/2010 08:07 PM, Chris Withers wrote: Sachin Srivastava wrote: Iirc, you have to change: RunAtLoad to RunAtLoad Sachin; can you confirm please? Yes. Though the daemon is loaded during startup. Will setting RunAtLoad to false not stop that? RunAtLoad = false means, the daemon is

Re: [GENERAL] how do I disable automatic start on mac os x?

n start it by using launchctl as ( sudo launchctl start com.edb.launchd. postgresql-8.4). Also you can always move/delete the plist file to avoid that also. -- Regards, Sachin Srivastava EnterpriseDB <http://www.enterprisedb.com>, the Enterprise Postgres <http://www.enterprisedb.com> company.

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

On 12/02/2009 09:42 AM, Craig Ringer wrote: On 2/12/2009 10:40 AM, Sachin Srivastava wrote: Dave: Are there sources available for the EnterpriseDB installer/packaging system? I'd like to get into the linux library path patcking problem myself, since nobody at EDB seemed to be interested i

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

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.

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

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] Postgresql8.4 install breaks Evolution on Ubuntu 9.10

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] initdb failing

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] initdb failing

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

[GENERAL] initdb failing

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

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

/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

  1   2   >