On 7/22/2014 11:42 PM, Kalai R wrote:
*why not use the installer, which sets it all up correctly for you?*
*
*
In previous, I use installer. but I face more data corruption problem
and also server starting problem when shutting down the system. so I
try to install my self.
*I think the pro
*why not use the installer, which sets it all up correctly for you?*
In previous, I use installer. but I face more data corruption problem and
also server starting problem when shutting down the system. so I try to
install my self.
*I think the problem is, you ran initdb as your user account,
On 7/22/2014 11:14 PM, Kalai R wrote:
*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
*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
*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 again, it's deployed to a Ubuntu image, but we're using chef to
configure the box. I know for a fact that chef starts and stops Postgresql
multiple times during the install so I'm pretty sure the MAIN log is from
the initial start, thank you too David G for pointing that out.
My next question
On 07/22/2014 09:01 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,
postgresql service didn't start. This happen
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= writes:
> On 22/07/14 16:58, Tom Lane wrote:
>> RelationGetNumberOfBlocks reports the length of the main fork ... but
>> this check is applied regardless of which fork we're reading. Should
>> be using RelationGetNumberOfBlocksInFork, of course.
> Thanks for fi
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
On Wed, 23 Jul 2014 00:16:47 +0200
klo uo wrote:
>
> Looking in process explorer, I see unusual size for postgres server
> process, i.e. working set reported around 1GB:
> http://i.imgur.com/HmkvFLM.png (same in attachment)
>
> I also use SqlExpress server with several databases (including spat
On 22/07/14 16:58, Tom Lane wrote:
> Doh. I looked right at this code in get_raw_page yesterday:
>
> if (blkno >= RelationGetNumberOfBlocks(rel))
> elog(ERROR, "block number %u is out of range for relation \"%s\"",
> blkno, RelationGetRelationName(rel));
>
> RelationGetN
-- Forwarded message --
From: Ramesh T
Date: Tue, Jul 22, 2014 at 7:50 PM
Subject: Re: [GENERAL] Need r_constraint_name
To: Adrian Klaver
Just i'm retriving the constraint_name when i enter child_table_name for
inner query and that constraint name is checking
parent_table on ou
Hi,
I run Windows and I started using 64 bit PostgreSQL 9.3 a month ago.
I have several PostGIS databases on localhost, with these statistics:
===
Xact
XactRolled Blocks Blocks TuplesTuples
S
Am a bit confused -which one comes first?
1) the 'data'||currval('id01_col1_seq') is parsed first : which means it
takes the current session's currval
2) then the insert is attempted which causes a sequence.nextval to be
performed which means that 'data'||currval('id01_col1_seq')will be
different
thank u ,
SELECT constraint_name
FROM information_schema.table_constraints AS tc
WHERE tc.table_name = p_table_name
AND constraint_name IN (SELECT constraint_name
FROM
information_schema.table_constraints AS tc
On Tue, Jul 22, 2014 at 9:46 AM, Anil Menon wrote:
> Am a bit confused -which one comes first?
>
> 1) the 'data'||currval('id01_col1_seq') is parsed first : which means it
> takes the current session's currval
> 2) then the insert is attempted which causes a sequence.nextval to be
> performed whi
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= writes:
> On 21/07/14 16:17, Tom Lane wrote:
>> Could you trace through it and see where the results diverge? Also,
>> what's the actual size of the file on disk?
> After a fresh restart of the database I attached strace to the backend.
> There are only 2 lines
On 07/22/2014 07:21 AM, Ramesh T wrote:
-- Forwarded message --
From: *Ramesh T* mailto:rameshparnandit...@gmail.com>>
Date: Tue, Jul 22, 2014 at 7:50 PM
Subject: Re: [GENERAL] Need r_constraint_name
To: Adrian Klaver mailto:adrian.kla...@aklaver.com>>
Just i'm retriving the c
David G Johnston wrote:
>> Also, I think that your method is vulnerable to race conditions:
>> If somebody else increments the sequence between the INSERT and
>> "SELECT lastval()" you'd get a wrong value.
>
> Uh, no. It returns that last value issued in the same session - which is
> race-proof.
On Tuesday, July 22, 2014, rob stone-2 [via PostgreSQL] <
ml-node+s1045698n5812384...@n5.nabble.com> wrote:
>
>
>
> On Tue, 2014-07-22 at 13:32 +, Albe Laurenz wrote:
>
> > rob stone wrote:
> > >> I have a question on the right/correct practice on using the serial
> > >> col's sequence for ins
On 21/07/14 16:17, Tom Lane wrote:
>> > db=# select page_header(get_raw_page(2836::oid::regclass::text, 'fsm',
>> > 1));
>> > ERROR: block number 1 is out of range for relation "pg_toast_1255"
>> > db=# select pg_relation_size(2836::oid::regclass, 'fsm');
>> > pg_relation_size
>> > --
On Tue, 2014-07-22 at 13:32 +, Albe Laurenz wrote:
> rob stone wrote:
> >> I have a question on the right/correct practice on using the serial
> >> col's sequence for insert.
> >>
> >> Best way of explanation is by an example:
> >>
> >> create table id01 (col1 serial, col2 varchar(10));
> >>
Albe Laurenz *EXTERN* wrote
> Also, I think that your method is vulnerable to race conditions:
> If somebody else increments the sequence between the INSERT and
> "SELECT lastval()" you'd get a wrong value.
Uh, no. It returns that last value issued in the same session - which is
race-proof.
http
On 07/22/2014 03:12 AM, Ramesh T wrote:
thank u ,
SELECT constraint_name
FROM information_schema.table_constraints AS tc
WHERE tc.table_name = p_table_name
AND constraint_name IN (SELECT constraint_name
FROM
infor
rob stone wrote:
>> I have a question on the right/correct practice on using the serial
>> col's sequence for insert.
>>
>> Best way of explanation is by an example:
>>
>> create table id01 (col1 serial, col2 varchar(10));
>>
>> insert into id01(col2) values ( 'data'||
>> currval('id01_col1_seq')::
On Mon, 2014-07-21 at 10:00 +0800, Anil Menon wrote:
> Hi,
>
>
> I have a question on the right/correct practice on using the serial
> col's sequence for insert.
>
>
> Best way of explanation is by an example:
>
>
> create table id01 (col1 serial, col2 varchar(10));
>
> insert into id01(c
Hi all!
I saw that Rails 4 comes with hstore support out of the box.
Does anyone know if there’s any integrated support like that in hibernate or
any other JPA implementation?
I know your able to write your own custom datatypes, but I’m looking for
integrated standardized support in the base lib
Hi,
2014-07-22 11:36 GMT+02:00 Rebecca Clarke :
> Hi all,
>
> Presently I'm executing a function that runs many queries within it.
>
> select * from _myfunction();
>
> Is there a way to see what query it is up to within the function?
>
Unfortunately, no. Even with the latest release. pg_stat_act
Hi all,
Presently I'm executing a function that runs many queries within it.
select * from _myfunction();
Is there a way to see what query it is up to within the function?
When I do a select of pg_stat_activity it just shows me the _myfunction()
query.
I'm running postgresql 9.1
Thanks in adva
29 matches
Mail list logo
