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:
http://postgresql.1045698.n5.n
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,
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
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
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
> 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
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
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
Is there any way to recover deleted record in Postgresql 9.2 if we don't
have any backup.
Thanks.
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
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
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
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
> 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
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
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
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
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-
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
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
21 matches
Mail list logo
