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 klep...@svana.org:
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?
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
jayadevan.maym...@ibsplc.com 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
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, expecting it
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
We have Jira + Confluence on postgres. Small site (25 users). No issues.
-Whit
On Mon, Aug 30, 2010 at 5:26 AM, Jayadevan M
jayadevan.maym...@ibsplc.com wrote:
Hello all,
Has any one worked with Jira on PostgreSQL?
We are considering Jira implementation for our organization (about 1500
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.
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
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 foreign
On 12/08/2010 03:43, Tom Lane wrote:
Marco Colombopg...@esiway.net 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
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 table
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 a.g.nienh...@gmail.com
To:
Terry Lee Tucker te...@chosen-ones.org 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
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/7463400:
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 br...@momjian.ushttp://momjian.us
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, wei...@lycos.com wrote:
Unfortunately, the statement doesn't work. I get an
On 26 Sie, 08:06, wstrzalka wstrza...@gmail.com 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
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 list
On 30 Aug, 00:02, björn lundin b.f.lun...@gmail.com 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
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
On Sunday, August 29, 2010, björn lundin b.f.lun...@gmail.com 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
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 for
On Mon, Aug 30, 2010 at 5:26 AM, Jayadevan M
jayadevan.maym...@ibsplc.com 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,
On Mon, Aug 30, 2010 at 10:08 AM, Marco Colombo pg...@esiway.net 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
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 no PK,
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 george@gmail.com:
On Mon, Aug 30, 2010 at 5:30
Yes. Look at the pg_statio% views in system catalog.
2010/8/30, Valoo, Julian julian.va...@fnb.co.za:
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
On Mon, 2010-08-30 at 15:42 -0400, Vick Khera wrote:
On Mon, Aug 30, 2010 at 10:08 AM, Marco Colombo pg...@esiway.net 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
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
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 cursor
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 yo...@karatedepot.com:
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
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
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
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 staltma...@gmail.com:
Hello!
I accidentally unplugged my computer and after restarting it my postgresql
gives me this error:
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
On Mon, Aug 30, 2010 at 2:53 PM, Yosef Haas yo...@karatedepot.com 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
2010/8/30 Scott Marlowe scott.marl...@gmail.com:
On Mon, Aug 30, 2010 at 2:53 PM, Yosef Haas yo...@karatedepot.com 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
2010/8/30 Yosef Haas yo...@karatedepot.com:
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
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
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:24
...
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
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 /
47 matches
Mail list logo