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:
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:
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
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
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.
Hello
2013/9/20 BOUVARD Aurélien aurelien.bouv...@supinfo.com
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,
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 be
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
Kaare Rasmussen ka...@jasonic.dk 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
Is there any way to recover deleted record in Postgresql 9.2 if we don't
have any backup.
Thanks.
AI Rumman rumman...@gmail.com 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
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.
On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin m.ma...@intershop.de 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
On Thu, Sep 19, 2013 at 12:02 AM, Dave Potts dave.po...@pinan.co.uk 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
Von: Merlin Moncure [mmonc...@gmail.com]
Gesendet: Freitag, 20. September 2013 17:43
On Fri, Sep 20, 2013 at 10:26 AM, Marc Mamin m.ma...@intershop.de wrote:
Hi,
here is a function which is about 8 x faster than the one described in the
PostgreSQL SQL Tricks
(
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 jeff.ja...@gmail.com wrote:
On Thu, Sep 19, 2013 at 12:02 AM, Dave Potts dave.po...@pinan.co.ukwrote:
Hi List
I am looking for some
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
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
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
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 -
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
21 matches
Mail list logo