eele [mailto:da...@pgmasters.net]
Sent: Friday, December 04, 2015 6:26 PM
To: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbasebackup help
On 12/3/15 12:59 AM, Yelai, Ramkumar IN BLR STS wrote:
> What I wanted to achieve is simple copy of Data folder. I
y understand correct? And am I doing the correct way to
backup.
Regards,
Ramkumar.
-Original Message-
From: David Steele [mailto:da...@pgmasters.net]
Sent: Thursday, December 03, 2015 1:27 AM
To: pgsql-general@postgresql.org; Yelai, Ramkumar IN BLR STS
Subject: Re: [GENERAL] Pgbaseba
Hi All,
I need some help in postgresql base backup.
We are currently using multiple DBMS in our project and postgresql is one of
them. Our private DBMS keeps the online data and postgresql keeps online as
well as historical data.
At present, we are doing the backup/restore process for our proj
Hi All,
I wanted to compile pgbouncer in Visual studio 2013-64bit.
I have not found any help in forums. Also, pgbouncer source file mentioned
that, it is not tested in Visual studio.
Please let me know, is it possible to compile in VS2013 and works fine?
With best regards,
Ramkumar Yelai
Si
sday, June 10, 2015 1:48 AM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] user constructed where clause
On Tue, Jun 9, 2015 at 4:48 AM, Yelai, Ramkumar IN BLR STS
mailto:ramkumar.ye...@siemens.com>> wrote:
Now, the requirement is if user provi
Hi All,
I have one requirement in my project and don't know how to achieve.
My project is receiving the log information from PC in the network, and that
information is stored in the below table.
CREATE TABLE "PCLogTable"
(
"LOG_ID" serial NOT NULL,
"LOG_USER_ID" integer DEFAULT 0,
"LOG_TY
Hi All,
I am using the following code to know how much disk space could be saved after
deleting certain tables (as a parameter to this function )
CREATE OR REPLACE FUNCTION Get_Tables_Recovery_Size( IN tableNames text[] )
RETURNS TABLE( table_size bigint )
AS
$$
DECLARE
BEGIN
RETURN QUE
Hi
I have migrated my postgresql 9.2 schemas to Postgres 9.4 (only table scheme
migrated not the data ). I have used the following sql to convert table output
to json in 9.2.
select array_to_json(array_agg(row_to_json(R.*)))::text from ( select " ID", "
TIME" from "SN_TestTable" )R;
IN 9.2,
Hi All,
We are using postgreql 9.2 as a main backend server for our project. We have
been using this server since last year. We have configured postgresql as a
windows service. Till last week, we have not faced any issues to start server
from service console management, but last week we hav
Thanks for your great inputs.
Let me see, how to handle these situations in our project.
Regards,
Ramkumar
-Original Message-
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Wednesday, August 28, 2013 1:09 AM
To: Jeff Janes
Cc: Yelai, Ramkumar IN BLR STS; pgsql
---
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: Tuesday, August 27, 2013 11:10 PM
To: Yelai, Ramkumar IN BLR STS
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgbouncer help
On Tue, Aug 27, 2013 at 1:34 AM, Yelai, Ramkumar IN BLR STS
wrote:
> HI
>
>
>
> In our current project
HI
In our current project, we are opening several postgresql connection. Few
connections are frequently used and few are occasionally used. Hence we plan to
adapt connection pool method to avoid more connection to open. We plan to use
"Pgbouncer". Most of the pgbouncer example shows how to
Ramkumar Yelai wrote:
[is worried that a database might become inconsistent if conflicting INSERTs
and DELETEs occur]
> @Albe - I got you first point. The second point is little skeptical
because postgres could have been
> avoided this lock by using MVCC. Please correct me if I am wrong?
Which
or I have write some example programming code on
this.
Thanks & Regards,
Ramkumar
From: Moshe Jacobson [mailto:mo...@neadwerx.com]
Sent: Wednesday, October 31, 2012 9:01 PM
To: Albe Laurenz
Cc: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Parallel Insert
Hi All,
Please clarify me the following example.
I have 2 tables
Table1 - ( it has one primary key and few columns )
Table2 - ( it has one primary key and few columns. It has one foreign key,
which refers table1 primary key ).
I have 2 operations, which are written in pl/pgsql procedure.
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Friday, September 28, 2012 1:07 PM
To: Yelai, Ramkumar IN BLR STS; pgsql-general@postgresql.org
Cc: scrawf...@pinpointresearch.com; and...@2ndquadrant.com
Subject: RE: [GENERAL] Re: Need help in reclaiming disk
I need to consider
carefully while doing this?
Thanks & Regards,
Ramkumar
_
From: Yelai, Ramkumar IN BLR STS
Sent: Thursday, September 13, 2012 7:03 PM
To: 'pgsql-general@postgresql.org'
Subject: Need help in reclaiming disk space b
Hi All,
I am a beginner in Postgresql and Databases. I have a requirement that
reclaiming disk space by deleting the rows in a selected time span. I went
through the documents and articles to know how to get the table size
(http://wiki.postgresql.org/wiki/Disk_Usage)
But before let the user d
18 matches
Mail list logo
