Hello all,
Has any one worked with Jira on PostgreSQL?
We are considering Jira implementation for our organization (about 1500
users).
The question is - "Jira on MySQL or Jira on PostgreSQL?" Any
tips/suggestions are welcome. We do not have much expertise in either of
these databases.
Oracle,
Thanks Martijn and to the others who replied. Here's some more detail...
Quoting Martijn van Oosterhout :
Not a bad start, but to be sure you really need to provide a bit more
info, like:
- How many simultaneous clients you're expecting?
- Lots of updates, or is it read only?
- Lots of simple
On 30/08/10 17:26, Jayadevan M wrote:
> Hello all,
> Has any one worked with Jira on PostgreSQL?
> We are considering Jira implementation for our organization (about 1500
> users).
> The question is - "Jira on MySQL or Jira on PostgreSQL?" Any
> tips/suggestions are welcome. We do not have much
Jayadevan M, 30.08.2010 11:26:
Hello all,
Has any one worked with Jira on PostgreSQL?
We are considering Jira implementation for our organization (about 1500
users).
The question is - "Jira on MySQL or Jira on PostgreSQL?" Any
tips/suggestions are welcome. We do not have much expertise in either
> Our admin team just moved our Jira from MySQL to PostgreSQL, but I
> can't recall the exact reasons anymore. So far we do not have any
> problems (from an end-user perspective that is)
>
Thanks for the reply. We plan to use it for our helpdesk, expecting it
to be up and running 24*7 (or as
On Mon, Aug 30, 2010 at 3:26 AM, Jayadevan M
wrote:
> Hello all,
> Has any one worked with Jira on PostgreSQL?
I did. The Jira admin edited the jdbc connect string, I created the
user, and the rest was pretty much autopilot.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On 30/08/10 18:13, Jayadevan M wrote:
>> Our admin team just moved our Jira from MySQL to PostgreSQL, but I
>> can't recall the exact reasons anymore. So far we do not have any
>> problems (from an end-user perspective that is)
>>
> Thanks for the reply. We plan to use it for our helpdesk, expe
Jayadevan M, 30.08.2010 12:13:
Our admin team just moved our Jira from MySQL to PostgreSQL, but I
can't recall the exact reasons anymore. So far we do not have any
problems (from an end-user perspective that is)
Thanks for the reply. We plan to use it for our helpdesk, expecting it
to be up a
We have Jira + Confluence on postgres. Small site (25 users). No issues.
-Whit
On Mon, Aug 30, 2010 at 5:26 AM, Jayadevan M
wrote:
> Hello all,
> Has any one worked with Jira on PostgreSQL?
> We are considering Jira implementation for our organization (about 1500
> users).
> The question is -
I am running 8.3.3 currently on this box.
Last week we had a database corruption issue that started as:
Aug 24 07:15:19 iprobe028 postgres[20034]: [3-1] ERROR: could not read
block 0 of relation 1663/16554/7463400: read only 0 of 8192 bytes
Aug 24 07:15:49 iprobe028 postgres[27663]: [3-1] ERROR:
Hi,
Assume tablex, tabley and tablez are correctly populated in my database.
My purpose is to enforce referential integrity between a column in the
tablex (the child)
and a column in tablez (the parent).
Since normal foreign keys do not give me this functionality, I decide
to write a trigger.
My
Hi
Are there any performance tuning tools for PostgreSQL, besides explain.
Any system management views to find out missing indexes or indexes that
are not being used.
Thanks
Julian Valoo
SQL Database Administrator
Corporate and Transactional Banking IT
BankCity
e-mail julia
On Monday, August 30, 2010 07:20:14 Maurice Gittens wrote:
> Hi,
>
> Assume tablex, tabley and tablez are correctly populated in my database.
>
> My purpose is to enforce referential integrity between a column in the
> tablex (the child)
> and a column in tablez (the parent).
>
> Since normal fo
On 12/08/2010 03:43, Tom Lane wrote:
Marco Colombo writes:
It's a matter of correctness: I see PG as a high
performance database system. Allowing to start it in awfully suboptimal
conditions it's no different from allowing '-00-00' as a date: it
may give you the idea you did the right thing
On Sun, Aug 29, 2010 at 11:30:57PM -0300, Carlos Henrique Reimer wrote:
> Hi,
>
> We had by mistake dropped the referencial integrety between two huge
> tables
Agora o elefante vai pegar! ;)
> and now I'm facing the following messages when trying to recreate
> the foreign key again:
>
> alter t
Unfortunately, the statement doesn't work. I get an error message about unable
to convert boolean to integer.
I have a look at the case statement for the conversion, but don't understand
how it works.
- Original Message -
From: "Arjen Nienhuis"
To: wei...@lycos.com
Cc: pgsql-general@
Terry Lee Tucker writes:
> On Monday, August 30, 2010 07:20:14 Maurice Gittens wrote:
>> So, it seems that even though my trigger is defined as AFTER INSERT
>> FOR EACH STATEMENT, the inserted row
>> does not appear to be included in the join.
>>
>> So, now to my question: Should, as a matter of
Excerpts from George Woodring's message of lun ago 30 08:17:56 -0400 2010:
> I am running 8.3.3 currently on this box.
> Last week we had a database corruption issue that started as:
>
> Aug 24 07:15:19 iprobe028 postgres[20034]: [3-1] ERROR: could not read
> block 0 of relation 1663/16554/746340
Is there a way to pass a psql variable into a \! command in psql, e.g.:
test=> \set x ls
test=> \! :x
:x: not found
I specifically want the currently connected database name to be passed
to a \! command.
--
Bruce Momjian http://momjian.us
EnterpriseDB
Maybe this works:
ALTER TABLE product ALTER status TYPE int USING CASE WHEN status THEN 1 ELSE
0 END;
If it doesn't, can you post the exact SQL you use and the exact error
message?
On Mon, Aug 30, 2010 at 5:27 PM, wrote:
> Unfortunately, the statement doesn't work. I get an error message about
On 26 Sie, 08:06, wstrzalka wrote:
> On 26 Aug, 01:28, pie...@hogranch.com (John R Pierce) wrote:
>
> > On 08/25/10 11:47 AM, Wojciech Strzałka wrote:
>
> > > The data set is 9mln rows - about 250 columns
>
> > Having 250 columns in a single table sets off the 'normalization' alarm
> > in my h
On 26 Aug, 01:28, pie...@hogranch.com (John R Pierce) wrote:
> On 08/25/10 11:47 AM, Wojciech Strzałka wrote:
>
> > The data set is 9mln rows - about 250 columns
>
> Having 250 columns in a single table sets off the 'normalization' alarm
> in my head.
>
> --
> Sent via pgsql-general mailing lis
On 30 Aug, 00:02, björn lundin wrote:
> Or is it just beeing late, and me being blind?
> eyetv=# select * from programmes where title like 'Star*';
It was of course me being blind...
select * from programmes where title like 'Star%';
is the correct way.
Wrong wildcard character '%' instead of
I got a table holding tv air time but I got a unexpected (to me)
behaviour.
Using like, I do not get the recordset I'd like.
I've installed it using mac-ports on an old mac-mini, ppc
I'd expect to see the same rows with wildcard, as I see without, see
below
Or is it just beeing late, and me bein
On Sunday, August 29, 2010, björn lundin wrote:
> eyetv=# select * from programmes where title like 'Star*';
* isn't the SQL wildcard character. % is.
--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."
--
Sent via pgsql-general mail
Excerpts from wstrzalka's message of jue ago 26 03:18:36 -0400 2010:
> So after turning off fsync & synchronous_commit (which I can afford as
> I'm populating database from scratch)
> I've stucked at 43 minutes for the mentioned table. There is no PK,
> constrains, indexes, ... - nothing except fo
On Mon, Aug 30, 2010 at 5:26 AM, Jayadevan M
wrote:
> The question is - "Jira on MySQL or Jira on PostgreSQL?" Any
>
We have Jira on postgres for project development work. Only about a
dozen users. Jira uses the DB as basic storage -- there are no
foreign keys, constraints, etc. Just a few ind
On Mon, Aug 30, 2010 at 10:08 AM, Marco Colombo wrote:
> Well, my idea was more along the line of "automatically try to acquire a
> reasonable amount of the available resources".
>
I challenge you to defined "reasonable" in a manner that will satisfy
more than 50% of the users in all possible use
No I don't, but definitely will try tomorrow
> Excerpts from wstrzalka's message of jue ago 26 03:18:36 -0400 2010:
>> So after turning off fsync & synchronous_commit (which I can afford as
>> I'm populating database from scratch)
>> I've stucked at 43 minutes for the mentioned table. There is n
I remember when I handled such situations without downtime, in 24/7 HA
setup, to avoid large transactions - You could try SELECT FROM A LEFT
JOIN B WHERE B.ID IS NULL LIMIT 10 -- and use this as a base for
DELETE statement...
2010/8/30, George H :
> On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique
Yes. Look at the pg_statio% views in system catalog.
2010/8/30, Valoo, Julian :
> Hi
>
>
>
> Are there any performance tuning tools for PostgreSQL, besides explain.
> Any system management views to find out missing indexes or indexes that
> are not being used.
>
>
>
> Thanks
>
>
>
>
>
>
>
> Julia
On Mon, 2010-08-30 at 15:42 -0400, Vick Khera wrote:
> On Mon, Aug 30, 2010 at 10:08 AM, Marco Colombo wrote:
> > Well, my idea was more along the line of "automatically try to acquire a
> > reasonable amount of the available resources".
> >
>
> I challenge you to defined "reasonable" in a manner
On Mon, Aug 30, 2010 at 05:04:36PM -0300, Carlos Henrique Reimer wrote:
> Hi
>
> Thank David and Georg for your suggestions.
>
> Yes, there is an index now defined on column protocolo in table
> posicoes_controles.
Legal!
> I've selected two suggested commands to compare which would be more
> p
Ok guys - there is something here that I am not seeing Can someone please
set me straight.
I am trying to create a cursor loop with an "update where current of "
statement, but my syntax is wrong.
Would one of you be able to tell me what I'm doing.
Also: adding "for update" to the curs1 curs
I have a table (transactions) with an order_date field that is varchar(32).
The data looks like this:
order_date
---
20100623 02:16:40
20100623 04:32:41
20100625 04:18:53
20100625 07:53:24
In my current database (8.1.4) if I run
select (*) from transactions where
Hello
2010/8/30 Yosef Haas :
> I have a table (transactions) with an order_date field that is varchar(32).
> The data looks like this:
>
>
>
> order_date
>
> ---
>
> 20100623 02:16:40
>
> 20100623 04:32:41
>
> 20100625 04:18:53
>
> 20100625 07:53:24
>
>
>
> In my current databa
Hello!
I accidentally unplugged my computer and after restarting it my postgresql
gives me this error:
ERROR: invalid page header in block 45 of relation base/16395/2608
What does it mean and how can I fix my db?
I don't have any backups and I'm not really good with databases in general(I
use it f
On Sat, 2010-08-28 at 12:50 -0700, Rich Shepard wrote:
> And, while postgres can be used, he
> prefers mysql and that's directly supported by Rails.
>
Although it seems more people use MySQL with rails than Postgres with
rails, they are both directly supported. And I believe that both have a
crit
Hello
maybe this article helps to you
http://blog.endpoint.com/2010/06/tracking-down-database-corruption-with.html
Regards
Pavel Stehule
2010/8/30 Roberts Staltmanis :
> Hello!
> I accidentally unplugged my computer and after restarting it my postgresql
> gives me this error:
> ERROR: invalid p
I know it would be best to change the data type of the column (I didn't
initially create the table), but doing so would be require changes to
several application that use it and I'd like to avoid that if possible.
Thanks,
Yosef Haas
yo...@karatedepot.com
-Original Message-
From: Pavel St
On Mon, Aug 30, 2010 at 2:53 PM, Yosef Haas wrote:
> I know it would be best to change the data type of the column (I didn't
> initially create the table), but doing so would be require changes to
> several application that use it and I'd like to avoid that if possible.
1. Most of those changes w
2010/8/30 Scott Marlowe :
> On Mon, Aug 30, 2010 at 2:53 PM, Yosef Haas wrote:
>> I know it would be best to change the data type of the column (I didn't
>> initially create the table), but doing so would be require changes to
>> several application that use it and I'd like to avoid that if possib
2010/8/30 Yosef Haas :
> I know it would be best to change the data type of the column (I didn't
> initially create the table), but doing so would be require changes to
> several application that use it and I'd like to avoid that if possible.
>
then you can dynamically transform data to timestamp
Hi Filip,
This was an excellent suggestion. I've run this join and just 2 minutes
later got 1000 records to delete.
Will start the deletes for them and then repeat the processing until all are
gone. With this approach I did not need to wait for the maintenance window
to fix the foreign key.
I t
On Mon, 2010-08-30 at 16:32 -0400, Yosef Haas wrote:
> I have a table (transactions) with an order_date field that is
> varchar(32). The data looks like this:
>
>
>
> order_date
>
> ---
>
> 20100623 02:16:40
>
> 20100623 04:32:41
>
> 20100625 04:18:53
>
> 20100625 07:53
I agree wholeheartedly with all of your points. The data should be in the
right format. The problem I'm faced with is that I'm in the middle of a
hosting migration and can't stop to change and deploy all the applications
that expect the date in that format.
Pavel did however point me in the right
Hi everyone.
I try this command ' pg_dump --compress=5 DBNAME > ***.sql ' and ' psql -f
***.sql -d DBNAME '
but I take some error because of compression. how can restore compressed
dump file without taking any error ?
thanks in advance
--
Yasin MALLI
Sistem ve Yazılım Geliştirme Mühendisi /
Syst
On 31 Aug 2010, at 6:44, yasin malli wrote:
> Hi everyone.
>
> I try this command ' pg_dump --compress=5 DBNAME > ***.sql ' and ' psql -f
> ***.sql -d DBNAME '
> but I take some error because of compression. how can restore compressed dump
> file without taking any error ?
By using pg_restore
On 31 Aug 2010, at 8:17, yasin malli wrote:
Don't reply to just me, include the list.
> if I took my dump file with 'pg_dump -Ft ' command, I would use 'pg_restore',
> but I take my dump file at plain-old format for compressing data ( tar format
> dump hasn't compress feature )
> when I tried y
49 matches
Mail list logo
