Thank You so much Krystian Bigaj.
Since last 2 years I had suffering this problem. But today I got solution
from you.
I am developing .Net application with Postgres.
I am using WCF service (host as windows service) to connect postgres
database.
*My workaround: own service which will start/stop Po
/cagxuano8jgxeplpfxg1whaopunfnrh_5hpze0jvhq9zgrq_...@mail.gmail.com
On Wed, Jul 23, 2014 at 7:39 PM, Adrian Klaver
wrote:
> On 07/22/2014 11:59 PM, Kalai R wrote:
>
>> * Is this a Windows *server* version, or is it one of the newer desktop
>>
>> OS's like Windows 8? Windows 8 seems
7.
In Windows 8 and Windows Server no problem.
*It seems like Windows isn't waiting for the service to exit cleanly before
its pulling the plug.*
I think so, but I don't know how to solve this problem.
On Wed, Jul 23, 2014 at 12:20 PM, John R Pierce wrote:
> On 7/22/2014 11:42
want to know why database corrupted even
though I shutting down the machine properly. This is frequently happen when
I use installer also.
On Wed, Jul 23, 2014 at 11:55 AM, John R Pierce wrote:
> On 7/22/2014 11:14 PM, Kalai R wrote:
>
>
>
> *Well the above would indicate it i
PM, Kalai R wrote:
>
>> Hi,
>>
>> I am facing a serious problem with postgresql frequently. I am using
>> postgresql 9.3 in Windows OS with VisualStudio. we have more customers.
>>
>> We shutting down the system properly. But when we booting system,
>>
*Well the above would indicate it is not being shutdown properly.How are
you shutting it down?*
PSQL server starterd as stoped by postgresql windows service. So when I
shutdown the machine postgres shutting down by postgres windows service
*What and how are you installing?*
Using windows binary
Hi,
I am facing a serious problem with postgresql frequently. I am using
postgresql 9.3 in Windows OS with VisualStudio. we have more customers.
We shutting down the system properly. But when we booting system,
postgresql service didn't start. This happens frequently after we install.
log detai
Hello,
Can I use windows default service account "LocalSystem" for psql service
account when installing.
On Thu, Jun 5, 2014 at 11:01 AM, Kalai R wrote:
> Thank You for your suggestions.
>
> In silent installation we use the following code in vb.net to install
>
r name, service account name and port.
Windows service account created automatically. We set only folder
permissions to the windows service account.
On Thu, Jun 5, 2014 at 8:08 AM, Adrian Klaver
wrote:
> On 06/03/2014 10:58 PM, Kalai R wrote:
>
>> Hi,
>>
>> Yesterday the psq
I have checked no problem in pg_hba.conf file.
Also I have disabled AV software checks for the Postgres Directories.
But Problem remains
On Thu, May 29, 2014 at 8:15 PM, Adrian Klaver
wrote:
> On 05/29/2014 07:34 AM, Kalai R wrote:
>
>> Hello,
>>
>> I am deve
Hello,
I am developing application using postgresql 9.3 and VS2005 as FrontEnd.
I am using silent installation method to install postgresql from .Net
application.
Postgresql installed and connected with application is fine
*The problem is* , when we on the system after shut down, postgresql
servi
Wed, Apr 23, 2014 at 7:11 PM, Tom Lane wrote:
> Kalai R writes:
> > I am using postgresql 9.3 in Windows. I take data backup using pg_dump.
> The
> > backup file size is 5 MB only. After that I insert 8 images using large
> > object.
>
> > The total size of 8 ima
Hello,
I am using postgresql 9.3 in Windows. I take data backup using pg_dump. The
backup file size is 5 MB only. After that I insert 8 images using large
object.
The total size of 8 images are 24 MB. After insert large object only, I
take data backup using pg_dump. Now the backup file size becom
Hi,
I am developing .Net application using PSQL. I am using npgsql to connect
PSQL database. In single database I have more than one schemas. After I
connect database I set search path using "Set Searchpath command" for the
required schema. It works perfectly.
But after sometime, I need to change
-- Forwarded message --
From: Kalai R
Date: Fri, Mar 22, 2013 at 9:36 AM
Subject: Re: [GENERAL] Problem in "Set search path"
To: Alban Hertroys
Hi,
Is that the same connection object in ,NET or the same connection to a
connection pool or the same database connecti
ement.
Regards
kalai
On Thu, Mar 21, 2013 at 6:09 PM, Pavel Stehule wrote:
> Hello
>
> 2013/3/21 Kalai R :
> > Hi,
> >
> >I am using postgresql 9.0.3. In my application I change often schema
> > name using set search path. Some times schema name set correctly
Hi,
I am using postgresql 9.0.3. In my application I change often schema
name using set search path. Some times schema name set correctly. But some
time it does not set correctly and it takes the schema previously I set.
Is any possibilities to happen like this?
Thank You.
stgres and
reinstall. Then the service start properly.
please suggest, what are the configurations should I do in postgres to
avoid these problem.
Thank You
On Sat, Oct 15, 2011 at 9:19 AM, Brar Piening wrote:
> Kalai R wrote:
>
>> Windows has been restoring a checkpoint with those dll'
Hi,
I find out the problem.
Windows has been restoring a checkpoint with those dll's not installed.
I don't know how to inatall dll.
Please help me to install those dll's in windows.
On Fri, Oct 14, 2011 at 5:12 PM, Alban Hertroys wrote:
> On 14 Oct 2011, at 12:25, Kalai
Hi,
I am facing this strange problem where my postgres service couldn't start
because of some missing dll files in installation directory's bin folder.
I copied files from other machine and it start working again. After some
time the same problem appeared again on system reboot.
I have no idea wha
Dear sir,
We are trying to install the Postgre-Sql 9.0. In some Win-Xp systems, the
postgre sql is installed & working properly. But in some Win-XP systems,
it was installed but the Service could not be started. In Win-Vista system,
even the Service is not installed. When we analysis the probl
Thanks to all.
I found the wrong configuration in pg_hba.conf. The problem is solved.
On Tue, Mar 29, 2011 at 8:02 PM, Raymond O'Donnell wrote:
> On 29/03/2011 14:59, Kalai R wrote:
>
>> Hi,
>> I am using Windows XP. When I have installed PostgreSQL 9.0.3, the
Hi,
I am using Windows XP. When I have installed PostgreSQL 9.0.3, the service
didn't start automatically. In the "Computer Management" I explicitly start
"postgresql-9.0" service, the service didn't start and following message
displayed
"The postgresql-9.0 service on Local Computer started and t
opening windows with Cancel , Retry, Ignore buttons. I want to ignore this
dialog box from my application without user interaction.
How could I do?
Kindly explain.
On Mon, Mar 28, 2011 at 7:54 PM, Vibhor Kumar wrote:
>
> On Mar 28, 2011, at 6:49 PM, Kalai R wrote:
>
> > I need to ins
Hi,
I need to install postgres 9 silently on Windows.
Kindly give the parameters list for postgres 9.0.3
Thanks & Regards
Kalai
Thank You to all for your suggestions.
Thank You Craig Ringer. Your suggestions are very useful to me. Now only, I
am collecting the data so at present I can't say, How much data I expect.
Now I got idea and confident to design my database. Thank you so much.
We are going to design database for a large company with multi branches. I
am using PostgreSQL
For example,
I create a single database for all branches. After 10 years, database size
is too large.
I want to know ,at that time, the performance of the database is reduced or
not.
Is it possible to
hi,
We are going to design database for a large company, which has many
branches. In each branch they maintain data separately and also they
maintain year wise data. ie
Company
|
Branch
|
Yearly
Also we need to compare and prepare reports by combine all branched data.
How should we
Thank You for your suggestion. Any other suggestions are welcome.
On Tue, Dec 7, 2010 at 4:50 PM, Vincent Veyron wrote:
>
> Le mardi 07 décembre 2010 à 13:42 +0530, Kalai R a écrit :
> > So please guide me, What should do to implement online postgresql
> > database?
&
Hi,
We are using PostgreSQL Database for our Desktop application using
VB.Net. It works well. Now we are going to develop online application. We
are new to online application. So please guide me, What should do to
implement online postgresql database?
Can we use VPS to create online databse? o
Sir,
I am using the following psql query with union and subqueries in my project.
select a.areaname,f.fmno,fm.mno,f.aliasno as falias,f.salutation as
fsal,f.headname, fm.aliasno as fmalias,fm.salutation as fmsal,fm.membername,
extract (year from age(now(), to_date(fm.dob,'-MM-dd'))) as age,
t; and what ever table space directories there are created.
>
> if the table spaces are on another Drive make sure the root has the
> account/group postgres is in has permissions to list directories, and
> contents. If not the account will be blocked from reading the drive
> contents re
ownership for postgres account?
Thanks in advance.
On Mon, May 3, 2010 at 6:49 PM, jus...@magwerks.com wrote:
>
> Message from Kalai R at
> 05-03-2010 05:41:24 PM --
>
> Hi,
> Sir,
> I have been checked pg_tblspc/86014 directory have no permission to
> create n
.
Regards
Gloier
On Wed, Apr 21, 2010 at 8:37 PM, Tom Lane wrote:
> Kalai R writes:
> > I have found a problem in my database. The following error occurs
> sometime
> > not any specific database operation.
>
> > ERROR:XX000:count not create temporary file
>
Sir,
I have found a problem in my database. The following error occurs sometime
not any specific database operation.
ERROR:XX000:count not create temporary file
"pg_tblspc/86014/pgsql_tmp/pgsql_tmp3568.0":No
such file or directory.
The above error received from the databas
Hi,
I wrote a function in plpgsql, to dispaly the student list.
In a Database all schemas contains studentlist table. so I wrote the
function with schemaname as a parameter(text data type). My code is
like
CREATE FUNCTION disp_fn(schemaname text) AS $$
BEGIN
SELECT * FROM schemaname.studentl
Hi ,
I have a problem in Postgres.
When adding a new field in the existing table, i want to add the filed in a
particular position. Is there any way to change the fields position in the
table. Any Solution to this problem would be much appreciated.
Thanks
Softlinne
hi,
i am near to PostgreSql. I create a database by the superuser. Then i create
another logon user. Now how can i protect my database from the new user. i
want to ban the access and view the database to the new user.It can done by
an entry in pg_hba file. Is there any other way to secure my datab
hi,
i am near to PostgreSql. I create a database by the superuser. Then i create
another logon user. Now how can i protect my database from the new user. i
want to ban the access and view the database to the new user.It can done by
an entry in pg_hba file. Is there any other way to secure my datab
39 matches
Mail list logo