Craig Ringer writes:
> On 7/06/2011 8:32 AM, Steve Crawford wrote:
>> I am working on my final 7.4 -> 9.0 upgrade. Data-type (auto-coalesce
>> and foreign-key), query and encoding issues are resolved. Dump/restore
>> is tested. But...
>>
>> I have a few old client systems that are difficult/infea
On 7/06/2011 8:32 AM, Steve Crawford wrote:
I am working on my final 7.4 -> 9.0 upgrade. Data-type (auto-coalesce
and foreign-key), query and encoding issues are resolved. Dump/restore
is tested. But...
I have a few old client systems that are difficult/infeasible to update.
I know the recommend
I am working on my final 7.4 -> 9.0 upgrade. Data-type (auto-coalesce
and foreign-key), query and encoding issues are resolved. Dump/restore
is tested. But...
I have a few old client systems that are difficult/infeasible to update.
I know the recommended procedure is to update clients ahead of
On 06/07/2011 04:18 AM, Heine Ferreira wrote:
Hi
Does Postgres run on the Starter Edition of Windows Vista and Windows 7?
As far as I know PostgreSQL is not explicitly tested on Windows ...
Starter Edition. Whether it will work depends on how crippled those
editions of Windows are.
Why wou
On 06/07/2011 04:17 AM, Heine Ferreira wrote:
Hi
Does Postgresql utilize hyperthreading and multiple cores on the
relevant processors on windows?
Sort-of. PostgreSQL runs many processes, one per query. Each process has
a single thread. This means that one query can use at most one CPU core,
On 06/06/2011 06:59 PM, Thomas Guettler wrote:
Hi,
how do you store recurring events in a database?
I use two tables: one table that stores the recurring event, and another
that's essentially a materialized view containing instances of the event.
It's not ideal, but performs better than usi
On 06/06/2011 09:26 PM, Condor wrote:
Can you explain little more how i can use database-level or user-level
SET commands to set log_statement for only one of them ?
http://www.postgresql.org/docs/current/static/sql-set.html
http://www.postgresql.org/docs/current/static/runtime-config-logging.
On Jun 5, 2011, at 4:02 PM, piscesboy wrote:
> I have a process called "java" showing up in my Activity Monitor that
> uses a good amount of CPU (4 - 8% average, 100 - 120% on occasion). It
> reports that "launchd" is its parent process and that postgres is its
> user.
>
> I did a ps axv|grep ja
On Mon, Jun 06, 2011 at 10:24:45PM +0200, Heine Ferreira wrote:
> I basicically want to avoid using upper in comparisons.
> Has anyone tried this?
> Do you know if this will work?
There's a contrib module that will allow you to do this. See the
citext datatype.
A
--
Andrew Sullivan
a...@crank
On Mon, Jun 6, 2011 at 2:24 PM, Heine Ferreira wrote:
> Hi
>
> I posted a similar question before. I was told that Postgres is always case
> sensitive.
> I was actually referring to text data not identifiers.
> I mean char and varchar fields.
> I basicically want to avoid using upper in comparison
PostgreSQL is process based. So it can be configured to use resources as
intensively as you like.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Heine Ferreira
Sent: Monday, June 06, 2011 1:17 PM
To: pgsql-general@postgresql.org
Subject: [GENER
Hi
I posted a similar question before. I was told that Postgres is always case
sensitive.
I was actually referring to text data not identifiers.
I mean char and varchar fields.
I basicically want to avoid using upper in comparisons.
With some databases you can use a utf8 characterset and a unicode
On Mon, Jun 6, 2011 at 4:17 PM, Heine Ferreira wrote:
> Hi
>
> Does Postgresql utilize hyperthreading and multiple cores on the relevant
> processors on windows?
>
> Thanks
>
> H.F.
>
>
It certainly looks like it on my machine! As far as my Linux box can tell,
the "hyperthreaded" CPUs just appear
Hi
Does Postgres run on the Starter Edition of Windows Vista and Windows 7?
Thanks
H.F.
Hi
Does Postgresql utilize hyperthreading and multiple cores on the relevant
processors on windows?
Thanks
H.F.
On Mon, Jun 6, 2011 at 10:20 AM, Tarabas wrote:
> Hello!
>
> I am currently having a recurring Locking problem on my Postgres 9.0.4
> Database. I had the same Problem on 9.0.1 and updated to 9.0.4 then.
> It worked fine for a while and just resurfaced.
>
> Suddenly it seems as though there is some
On Mon, Jun 6, 2011 at 11:20 AM, Tarabas wrote:
> Hello!
>
> I am currently having a recurring Locking problem on my Postgres 9.0.4
> Database. I had the same Problem on 9.0.1 and updated to 9.0.4 then.
> It worked fine for a while and just resurfaced.
>
> Suddenly it seems as though there is some
On Mon, Jun 6, 2011 at 7:26 AM, Condor wrote:
> On Mon, 06 Jun 2011 18:53:57 +0800, Craig Ringer wrote:
>>
>> On 6/06/2011 4:14 PM, Condor wrote:
>>>
>>> Hello ppl,
>>> any one can tell me how i make my postgresql server to log commands
>>> coming from another postgres server ? I have one postgres
On 06/02/11 6:54 AM, eyal edri wrote:
when i try to run any command that uses the xml file for auth, it
failes with:
FATAL: Ident authentication failed for user "postgres"
ident authentication means unix user "joe" can only authenticate as
postgres user/role "joe" (unless you set up an ident
Hello!
I am currently having a recurring Locking problem on my Postgres 9.0.4
Database. I had the same Problem on 9.0.1 and updated to 9.0.4 then.
It worked fine for a while and just resurfaced.
Suddenly it seems as though there is some kind of "deadlock" in the
database, which prevents my client
On Mon, 06 Jun 2011 18:53:57 +0800, Craig Ringer wrote:
On 6/06/2011 4:14 PM, Condor wrote:
Hello ppl,
any one can tell me how i make my postgresql server to log commands
coming from another postgres server ? I have one postgresql and give
to
2 other sql server to access my db. I want to log a
Hi,
how do you store recurring events in a database?
Selecting all events in a week/month should be fast (comming from an index).
My solution looks like this:
Table event:
Columns: id, name, recurring, start_datetime, end_datetime
recurring is weekly, monthly, yearly or NULL.
end_datetime ca
On 6/06/2011 4:14 PM, Condor wrote:
Hello ppl,
any one can tell me how i make my postgresql server to log commands
coming from another postgres server ? I have one postgresql and give to
2 other sql server to access my db. I want to log all query's coming
only from one of the servers. Is that pos
On 5/06/2011 11:17 PM, Andre Majorel wrote:
Does anyone know of a document comparing SQLite and PostgreSQL ?
It'd help a lot if you explained your use case. What do you need a
database for? In what environment? With what hardware? Who will be
running it? etc.
--
Craig Ringer
Tech-related
I have a couple of tables (people and addresses) which are using
serials as primary keys and contain many potentially duplicate data in
them. The problem is that the data has not been input in a careful way
so for example you have a first_name, middle_name and last_name fields
but you could have Sa
On Mon, 6 Jun 2011 11:55:47 +0200, Magnus Hagander wrote:
On Jun 2, 2011 4:16 PM, "eyal edri" wrote:
>
> Hi,
>
> Im trying to use postgres with ident auth and jboss.
>
> heres my postgres files:
>
> pg_hba.conf:
>
> # TYPE DATABASE USER CIDR-ADDRESS
METHOD
>
> #
On Jun 2, 2011 4:16 PM, "eyal edri" wrote:
>
> Hi,
>
> I'm trying to use postgres with ident auth and jboss.
>
> here's my postgres files:
>
> pg_hba.conf:
>
> # TYPE DATABASEUSERCIDR-ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all
Hello ppl,
any one can tell me how i make my postgresql server to log commands
coming from another postgres server ? I have one postgresql and give to
2 other sql server to access my db. I want to log all query's coming
only from one of the servers. Is that possibly ?
--
Regards,
Condor
--
28 matches
Mail list logo