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
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
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
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
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
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
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
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
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
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
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
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!
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
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
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
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
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
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
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
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
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
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
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
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 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
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 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
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 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
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
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
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
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
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@
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
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 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
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
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
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:
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 -
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
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
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)
> 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
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
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
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
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,
49 matches
Mail list logo
