Eduard-Cristian Stefan wrote:
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home
Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following sett
If #1 was solved by using the raid approach, what happens if one of
the disks containing one of my table spaces crashes.
if you are using raid, your tablespaces are on raid volumes comprised of
2 or more drives, any one of those drives may fail, and the full data is
still available. if you
On Thu, Jun 23, 2011 at 7:14 PM, Rodrigo E. De León Plicet
wrote:
> Here:
>
> http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
>
> Any comments?
That is quite possibly one of the most ignorant opinion pieces I've
ever read. The janitor in Dilbert is significantly
On 23/06/11 22.39, Tomas Vondra wrote:
Dne 23.6.2011 20:39, Edoardo Panfili napsal(a):
I Have the same problem: one ID must be unique.
Three tables inherits from the same parent table the id column, the ID
is is defined as:
id bigint DEFAULT nextval('sequence_name')
in the parent table.
Can I a
I have an application for which data is being written to many disks
simultaneously. I would like to use a postgres table space on each
disk. If one of the disks crashes it is tolerable to lose that data,
however, I must continue to write to the other disks.My specific
concerns are:
1.
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following settings:
data_directory = '../../
Sorry for the late reply - but I still haven't found a solution,
for example I have a PHP script with 5 consecutive SELECT
statements (source code + problem described again under:
http://stackoverflow.com/questions/6458246/php-and-pgbouncer-in-transaction-mode-current-transaction-is-aborted
) and
> On 06/24/2011 09:14 AM, Rodrigo E. De León Plicet wrote:
> I'm quite surprised the article didn't mention the importance of having
> "somebody to sue if it goes wrong", which is a comment I often see made
> re Oracle. It's lucky they didn't try to stress that point, because
> evidence of succes
This message has been digitally signed by the sender.
Re___GENERAL__Oracle___PostgreSQL_comparison___.eml
Description: Binary data
Hi-Tech Gears Ltd, Gurgaon, India
Sent using "PostMaster" by QuantumLink Communications
Get your fre
> > http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgre
> > sql.html
> >
> > Any comments?
>
> Amusing.
>
> "
> What kind of support is available if we have a problem? What is their
> patching schedule to address exploits and known security defects? If
> there is a bug, h
On 06/24/2011 09:14 AM, Rodrigo E. De León Plicet wrote:
Here:
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
Any comments?
He's been working with Oracle too long, and forgotten that it's a
database not a career and a lifestyle?
More seriously: it's all a
On 06/23/2011 10:28 PM, Stephen Frost wrote:
Next, PG doesn't even use the same basic technology as Oracle regarding
how transaction isolation and versioning works. Oracle using rollback
segments to store 'old' rows in, while PG uses a Multi-Version
Concurrency Control (MVCC) system. They're fu
> http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
>
> Any comments?
Amusing.
"
What kind of support is available if we have a problem? What is their
patching schedule to address exploits and known security defects? If
there is a bug, how responsive is the organi
* Rodrigo E. De León Plicet (rdele...@gmail.com) wrote:
> Any comments?
Sure, they've never bothered to actually look at the data. Consider
that for quite a while Oracle essentially refused to admit that their
could *possibly* be bugs in their system (see: Unbreakable Linux, or
whatever that fool
Here:
http://cglendenningoracle.blogspot.com/2011/06/oracle-vs-postgres-postgresql.html
Any comments?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Steve Atkins wrote:
> On Jun 20, 2011, at 10:49 PM, CSS wrote:
>
>> Hello,
>>
>> I couldn't find much information in the archives on this -- perhaps this
>> is a bit of a specialized need, but I was hoping for some input from
>> some experienced postgres admins.
>>
>> I'm moving some DNS servers f
Greg Smith wrote:
> On 06/21/2011 01:49 AM, CSS wrote:
>> Some raw numbers: We're only looking at a total of about six tables in
>> one db. In total there are going to be well under 10,000 records in ALL
>> tables. That might increase to at most 100,000 in the next few years.
>> Our raw DNS queri
>
> Possibly:
> test=> select (to_date('30/12/2007','DD/MM/') +
> '00:30'::time)::timestamp;
>timestamp
> -
> 2007-12-30 00:30:00
> (1 row)
>
>
Great, so now I have to capture the date and time portion of the string
separately AND I need to use two parameters i
the 2nd example on http://wiki.postgresql.org/wiki/Index_Maintenance
doesn't work on 8.4 or 9.0 unless you add ::text to the arguments of
the two pg_relation_size calls near the beginning.
I don't have wiki edit privs and don't see a way to register so I'm
hoping someone who does can fix that
On Thursday, June 23, 2011 1:42:42 pm hernan gonzalez wrote:
> Fair enough: to_timestamp doesn't do what I want, I must resort to casting.
>
> But it's rather unfortunate that a to_timestamp() function doesnt actually
> parse a "timestamp" (which, is a alias to "timestamp without timezone", at
>
> On 22/06/11 18.30, David Johnston wrote:
> > The only (obvious to me) way to really solve the problem - invisibly -
> > is to allow for table-less unique indexes that multiple tables can
> > share and that have a pointer to the "source" table for any particular
entry
> in the index.
> > The other
> -Original Message-
> >
> > Every feature and function in PostgreSQL is "potentially dangerous"
> > - understanding them and using them correctly is the responsibility
> > of the programmer. Time handling has lots of subtleties that take
> > time to digest
> >
> >
> > Than
>
>
> Every example here starts, at its core, with to_timestamp. That function
> returns a timestamp *with* time zone so of-course the current timezone
> setting will influence it. Stop using it - it doesn't do what you want.
>
> If you cast directly to a timestamp *without* time zone you can take
Dne 23.6.2011 20:39, Edoardo Panfili napsal(a):
> I Have the same problem: one ID must be unique.
> Three tables inherits from the same parent table the id column, the ID
> is is defined as:
> id bigint DEFAULT nextval('sequence_name')
> in the parent table.
>
> Can I assume that a sequence ensure
On Thu, 2011-06-23 at 13:26 -0700, Adrian Klaver wrote:
> On 06/23/2011 01:07 PM, Steve Crawford wrote:
> > On 06/23/2011 12:30 PM, hernan gonzalez wrote:
> >>
> >>
> >> On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
> >> mailto:adrian.kla...@gmail.com>> wrote:
> >>
> >> On 06/23/2011 11:40 AM
On 06/23/2011 01:07 PM, Steve Crawford wrote:
On 06/23/2011 12:30 PM, hernan gonzalez wrote:
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
mailto:adrian.kla...@gmail.com>> wrote:
On 06/23/2011 11:40 AM, hernan gonzalez wrote:
Rather than being not viable, I'd argue that is is no
On 06/23/2011 12:30 PM, hernan gonzalez wrote:
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver
mailto:adrian.kla...@gmail.com>> wrote:
On 06/23/2011 11:40 AM, hernan gonzalez wrote:
Rather than being not viable, I'd argue that is is not correct.
Rather, a simple dir
On Thu, Jun 23, 2011 at 4:15 PM, Adrian Klaver wrote:
> On 06/23/2011 11:40 AM, hernan gonzalez wrote:
>
>>Rather than being not viable, I'd argue that is is not correct.
>>Rather, a simple direct cast will suffice:
>>'2011-12-30 00:30:00'::timestamp without time zone
>>
>>
>> That wo
On 06/23/2011 11:40 AM, hernan gonzalez wrote:
Rather than being not viable, I'd argue that is is not correct.
Rather, a simple direct cast will suffice:
'2011-12-30 00:30:00'::timestamp without time zone
That works only for that particular format. The point is that, for
example, i
> Rather than being not viable, I'd argue that is is not correct. Rather, a
> simple direct cast will suffice:
> '2011-12-30 00:30:00'::timestamp without time zone
>
That works only for that particular format. The point is that, for example,
if I have some local date time
stored as a string in ot
On 22/06/11 18.30, David Johnston wrote:
The only (obvious to me) way to really solve the problem - invisibly - is to
allow for table-less unique indexes that multiple tables can share and that
have a pointer to the "source" table for any particular entry in the index.
The other method being disc
On 06/23/2011 09:01 AM, hernan gonzalez wrote:
to_timestamp() returns a TIMESTAMP WITH TIME ZONE
Perhaps an alternative that returns a TIMESTAMP WITHOUT TIME ZONE
(which, BTW, is the default TIMESTAMP)
should be provided. Elsewhere, there is no direct-robust way of
parsing a TIMESTAMP WITHOU
There is some related discussion here
http://postgresql.1045698.n5.nabble.com/to-timestamp-returns-the-incorrect-result-for-the-DST-fall-over-time-td3327393.html
But it amounts to the same thing: TO_TIMESTAMP() is not apt for dealing with
plain TIMESTAMP
(without time zones).
Hence, there is no f
For you reading pleasure :-).
http://schmichael.com/files/schmongodb/Scaling%20with%20MongoDB%20(with%20notes).pdf
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 2011-06-23 19:15, Reid Thompson wrote:
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
not very familiar with the windows version, but I think -D is supposed to point
to the data directory which in yo
On 06/23/2011 11:08 AM, Eduard-Cristian Stefan wrote:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
not very familiar with the windows version, but I think -D is supposed to point to the data directory which in your later info is
listed as
data_direct
I have PostgreSQL 9.0.4-1 running as a service on Windows XP Home Edition,
with the command line of the service being:
D:\me\usr\PostgreSQL\bin/pg_ctl.exe runservice -N "pgsql" -D
"d:/me/etc/PostgreSQL"
In the postgresql.conf file I have the following settings:
data_directory = '../../
to_timestamp() returns a TIMESTAMP WITH TIME ZONE
Perhaps an alternative that returns a TIMESTAMP WITHOUT TIME ZONE (which,
BTW, is the default TIMESTAMP)
should be provided. Elsewhere, there is no direct-robust way of parsing
a TIMESTAMP WITHOUT TIME ZONE (which
represesents a "local date-time"
I remember a few months ago that someone said that the UUID-OSP contrib
module did not work on Windows 64. Is this still a limitation?
Best Regards
Michael GouldIntermodal Software Solutions
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
The result needs to be sorted by date of most recent reply descending
(replying bumps the thread) but also need to be sorted such that the
parent/child relationships are maintained. Multiple replies on the same
level also need to be sorted by date desc.
Getting the parent/child sorting can be a
My postgresql instance was last started on Apr21.
In my temp space directory, I have various files that I believe are orphaned.
Given the information below, can I safely rm the files in
/mnt/iscsi/psql_tmp/tmpdata/41099 that are older than Jun 22?
If yes, should these files have been cleaned up b
I am trying to select nested comments from a table with this structure
CREATE TABLE picture_comments
(
comment_id serial NOT NULL,
user_id integer NOT NULL,
"comment" text NOT NULL DEFAULT ''::text,
comment_date timestamp without time zone NOT NULL DEFAULT now(),
On Thursday, June 23, 2011 12:24:12 am Aritz Dávila wrote:
> Hi list,
>
>
> Another strange thing is the following one, if I do the following on the
> database server: psql -h localhost -d database, I grant access but if I do
> the following psql -h 192.168.2.122 -d database on the database serv
2011/6/23 Gábor Farkas :
> 2011/6/23 Thom Brown :
>> 2011/6/23 Gábor Farkas :
>>> hi,
>>>
>>> postgresql8.4.7 here.
>>>
>>> i checked the pg_stat_user_tables table, and it have a lot of rows
>>> there where the "last_autovacuum" and/or "last_autoanalyze" are null.
>>> does this mean that autovacuum
On Thursday, June 23, 2011 12:24:12 am Aritz Dávila wrote:
> Hi list,
>
> I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
> remote access to this database so after reading I found out that modifying
> pg_hba.conf and postgresql.conf will allow me to access remotely.
>
2011/6/23 Thom Brown :
> 2011/6/23 Gábor Farkas :
>> hi,
>>
>> postgresql8.4.7 here.
>>
>> i checked the pg_stat_user_tables table, and it have a lot of rows
>> there where the "last_autovacuum" and/or "last_autoanalyze" are null.
>> does this mean that autovacuum never worked on those tables?
>>
>
On 6/23/11 3:24:12 AM, Aritz Dávila wrote:
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is
On 23/06/2011 08:24, Aritz Dávila wrote:
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is o
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is on 192.168.2.122. The port 5432 is open, c
Hello Gavin,
On Wed, 22 Jun 2011 20:53:19 +1200
Gavin Flower wrote:
> [...]
>This design ensures that: names of towns are unique within a given
>country and >region.
>Note you will still need business logic, in a trigger or some such, to
>ensure that only one town within a given country and
2011/6/23 Gábor Farkas :
> hi,
>
> postgresql8.4.7 here.
>
> i checked the pg_stat_user_tables table, and it have a lot of rows
> there where the "last_autovacuum" and/or "last_autoanalyze" are null.
> does this mean that autovacuum never worked on those tables?
>
> roughly 70% of all the tables ha
hi,
postgresql8.4.7 here.
i checked the pg_stat_user_tables table, and it have a lot of rows
there where the "last_autovacuum" and/or "last_autoanalyze" are null.
does this mean that autovacuum never worked on those tables?
roughly 70% of all the tables have null in those fields..
in those never
52 matches
Mail list logo
