On 21/09/13 02:51, Gregory Haase wrote:
I would look towards how PostGis handles the Tiger census data for
guidance. It's a similar, massive data set.
Greg Haase
I'm not sure why it wouldn't handle it fine?
The question is at what point would third party "imported" datasets,
required for l
It should be possible to install the SW without initializing the cluster.
That way you may be in a better position to troubleshoot the issue.
Complete the installation, then use initdb to initialize a cluster. Have a
look at this url too -
http://wiki.postgresql.org/wiki/Running_%26_Installing_Post
Hi,
If I aquire a lock on table B which is inherited from table A, Table A seems to
be also locked (postgres 9.2).
Is there a way to get around it ?
I couldn't find any information about this behavior in the documentation.
Thanks
Manuel Kniep
--
Sent via pgsql-general mailing list (pgsql-
Hi,
We are having a problem installing Postgres 9.3 on Windows 7 pro.
The installation freezes and you can leave it running overnight without any
error messages.
The Bitrock log's last entries are:
[14:45:43] Removing the existing ldconfig setting - set during the previous
instal
Given this table
articles_1=> \d hits_user_daily_count;
Table "public.hits_user_daily_count"
Column | Type | Modifiers
---+-+---
userid| integer | not null
date | date| not null
num
I would look towards how PostGis handles the Tiger census data for
guidance. It's a similar, massive data set.
Greg Haase
On Sep 20, 2013 9:47 AM, "Jeff Janes" wrote:
> On Thu, Sep 19, 2013 at 12:02 AM, Dave Potts wrote:
>
>> Hi List
>>
>> I am looking for some general advice about the best was
> Von: Merlin Moncure [mmonc...@gmail.com]
> Gesendet: Freitag, 20. September 2013 17:43
>
> > On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin wrote:
> > Hi,
> > here is a function which is about 8 x faster than the one described in the
> > PostgreSQL SQL Tricks
> > (
> > http://postgres.cz/wiki
On Thu, Sep 19, 2013 at 12:02 AM, Dave Potts wrote:
> Hi List
>
> I am looking for some general advice about the best was of splitting a
> large data table,I have 2 different choices, partitioning or different
> schemas.
>
I don't think there is much of a choice there. If you put them in
dif
On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin wrote:
> Hi,
> here is a function which is about 8 x faster than the one described in the
> PostgreSQL SQL Tricks
> (
> http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code
> )
>
> The idea is to handle each encoded/not_enc
Hi,
here is a function which is about 8 x faster than the one described in the
PostgreSQL SQL Tricks
(
http://postgres.cz/wiki/PostgreSQL_SQL_Tricks#Function_for_decoding_of_url_code
)
The idea is to handle each encoded/not_encoded parts in bulk rather than
spliting on each character.
urldeco
AI Rumman wrote:
> Is there any way to recover deleted record in Postgresql 9.2 if
> we don't have any backup.
I would recommend following the advice here *immediately*:
http://wiki.postgresql.org/wiki/Corruption
Any recoverable data may be disappearing through normal maintenance
operations as
Is there any way to recover deleted record in Postgresql 9.2 if we don't
have any backup.
Thanks.
Kaare Rasmussen writes:
> Hi
>
> I'm trying to determine the best way to represent a simple tree
> structure (like a file/dir tree or a uri path). I guess that's done a
> zillion times before; I just don't seem to be able to find the right
> solution. I have one special request, that I'd like to
On 09/19/2013 06:04 PM, Dave Cramer wrote:
Adrian,
2) The exact error message is ERROR: extra data after last expected column
considering ~39000 lines go in before this line I am fairly certain it is the
line.
New day, new start. I am not sure now that the line you showed is the
probl
> 1. As strings
> There's no dedicated function (@>)
> WHERE clause should read something like 'a/b/c/d' LIKE column || '%',
> which is both ugly and (I guess) non indexable
> Perhaps regex indexes would work, but not efficient and not optimal
>
> 2. As array of strings
> My favorite, would
Hello
2013/9/20 BOUVARD Aurélien
> Hi ,
>
> Maybe it will help you : http://orafce.projects.pgfoundry.org/
>
orafce was moved to github https://github.com/orafce/orafce
Regards
Pavel
>
> Regards,
>
>
> Aurélien
>
>
> Afin de contribuer au respect de l'environnement, merci de n'imprimer c
Hi
I'm trying to determine the best way to represent a simple tree
structure (like a file/dir tree or a uri path). I guess that's done a
zillion times before; I just don't seem to be able to find the right
solution. I have one special request, that I'd like to find all
'shorter' paths, i.e. g
Hi,
Have a look at orafce for the plugins. Try ora2pg for initial migration.
There are differences in how you execute procedures (syntax), packages are
missing in PostgreSQL and so on. Please have a look at
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Oracle
Regar
Hi ,
Maybe it will help you : http://orafce.projects.pgfoundry.org/
Regards,
Aurélien
Afin de contribuer au respect de l'environnement, merci de n'imprimer ce mail
qu'en cas de nécessité.
-Message d'origine-
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@p
Hi
I am planning to migrate oracle database to postgres. I need to know
if there are any plugins or tool with which I can use stored procedures
written in oracle schema for postgres with out changing them.
Thanks in advance
--
View this message in context:
http://postgresql.1045698.n5.n
Hi,
How about the following two areas?
step 3: wait until the failover is completed, the server is brought up after
applying all WAL files available in the archive.
Question 1: How to check if the failover is completed and the new Primary is
ready?
step 4: if the failover is done
Question 2:
21 matches
Mail list logo
