Hi All,
I want to migrate from PostgreSQL to Oracle and need any tool preferably open
source. And I am specially concerned with stored procedures / functions.
Regards,
Abdul Rehman.
Hi all,
Is there any preferably open source tool to convert Oracle Functions to
PostgreSQL Functions.
Thanks,
Abdul Rehman.
ards,
Abdul Rehman.
From: Richard Huxton
To: Abdul Rahman
Cc: pgsql-general@postgresql.org; ashis...@synechron.com
Sent: Wednesday, February 18, 2009 2:13:27 PM
Subject: Re: [GENERAL] Download link for 'Bristlecone'
Abdul Rahman wrote:
> Dear All,
Simply use '\o filename' as you are doing so. Write the queries as much as you
want. It will automatically append the result in the specified file. Untill you
use '\o' command again with new file name.
Dear All,
I searched a lot but failed to find any download link for Bristlecone. Kindly
help me. Or let me know about any open source Load Tester for PostgreSQL based
application.
Ashish, according to my search Bristlecone is open source. Thanks in advance.
Regards,
Abdul Rehman.
Hi all,
Can any body tell me about tool for PostgreSQL load testing preferably
freeware.
Regards,
Abdul Rehman.
Kindly let me know two things to answer you. First, Are you trying to start
postgres service or psql prompt? second, what OS is in your use.
Dear All,
Thanks John R Pierce for replying fruitful text. I wold like to add some text
in your reply from PostgreSQL document for further clarification. i.e.
Each connection runs one process, plus the 3 master processes for the
postmaster, the writer, etc. with two logins, I'd expect to s
Dear All,
I have fear that sufficient increase in number of postgres.exe after one or two
logins on servers may down the speed of the server or even server. Is there any
solution or technique to overcome this overhead.
Regards,
Abdul Rehman.
.
From: Abdul Rahman
To: pgsql-general@postgresql.org
Sent: Wednesday, February 11, 2009 12:09:25 PM
Subject: Key Vs Index
In Oracle, the index is automatically created during the creation of Primary
Key. But in PostgreSQL either index is implicitly created
In Oracle, the index is automatically created during the creation of Primary
Key. But in PostgreSQL either index is implicitly created of the user hast
create it explicitly. I don't find any index against Primary Key and have to
create index on this key.
ount of time to perform something
else before the execution of same query today.
From: Jaime Casanova
To: Abdul Rahman
Cc: pgsql-general@postgresql.org
Sent: Wednesday, January 28, 2009 12:20:41 PM
Subject: Re: Rollback of Query Cancellation
On Wed, Jan 28,
Very nice!
Most probably it was waiting for something else. This is the reason the query
executed today and clearly showed certain number of rows deleted. But what ELSE?
From: Sim Zacks
To: Abdul Rahman
Sent: Wednesday, January 28, 2009 12:08:28 PM
Subject
he target machine actively refused it.
2009-01-27 18:52:08 LOG: unexpected EOF on client connection
Here, I am talking about the last query (Bold_Italic). Now my question is still
stands. Kindly continue to up your valuable text.
From: Jaime Casanova
To: Abdu
Welcome Jcasanov,
Here is the output of the log files:
2009-01-27 09:24:18 FATAL: the database system is starting up
2009-01-27 09:24:19 LOG: database system was shut down at 2009-01-26 18:34:53
2009-01-27 09:24:19 LOG: checkpoint record is at 0/1B9F92C8
2009-01-27 09:24:19 LOG: redo record i
Thanks Justin,
Answers of your technical
questions are as under:
What does the sql statement look like?
delete from ci_cif_v where
req_id='0824100207';
Where was the statement run?
On SQL pan of pgAdmin-III
How was the statement killed?
By
clicking the Cancel Query button ->
What do the logs show?
Dear All,
Yesterday I canceled a running query because it was taking long time (more than
12 minutes) to delete lots of records. Today when I executed the same query it
hardly took few seconds to finish. It clearly explores that PostgreSQL does not
perform rollback action. Is it true?
Regards,
Thanks Ray,
Your solution of using ps command is for Linux but I am using WinXp. That is
why it confused me.
Regards,
Abdul Rehman.
Dear All,
Thanks for fruitful replies. But I checked it by running ANALYZE on psql. First
updated 1 rows in a table and got certain number of dead rows in result of
ANALYZE. After few minutes the number of dead rows becomes zero which assured
me that AUTOVACUUM is running in background.
No
Deal All,
I have set postgresql.conf for autovacuum and need to know weather the process
is running/working or not.
Regards,
Avdul Rehman.
That's it!
Arora your document
(http://wiki.postgresql.org/wiki/Image:PgAgent_for_windows.doc) is better than
the best. The error was of postgress user rights and nothing else. After
granting rights to postgres Its really running well.
Thanks.
From: Vishal A
I have found via cmd prompt. My Computer (GUI) is not showing the path and file
(pgpass.conf). However, the size of this file is 0kb i.e. nothing is written in
this file.
- Forwarded Message
From: Abdul Rahman <[EMAIL PROTECTED]>
To: Vishal Arora <[EMAIL PROTECTED]>; [EMA
I searched but didn't find any pgpass.conf file.
From: Vishal Arora <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Thursday, November 27, 2008 5:27:26 PM
Subject: RE: [ADMIN] PgAgent Job Scehduler is NOT runni
Thanks Vishal,
I followed the document and now the statistics of the job is appearing and
showing successful but actually backup is not made via this job. In output tab
it gives the following error:
could not open the file "D:\xxx.backup":Permission denied.
I tried to perform the task from bot
Service is running. After getting frustrated I dropped the pgagent schema and
reworked. But the result is same. ???. Even entries in the concerned pga_tables
is also very clear. Perhaps the trigger is not working .
From: Vishal Arora <[EMAIL PROTECTED]>
To: [E
No error message appeared. Because NOstatistics is available for the job. It
reflects that it is not running.
- Forwarded Message
From: Vishal Arora <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 11:47:33
No error message appeared. Because statistics is available for the job. It
reflects that it is not running.
From: Vishal Arora <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; pgsql-general@postgresql.org
Cc: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2008 11:47:
Dear all,
I installed PgAgent and started its service and successfully scheduled a
backup and got 100% result. Now the same Job is not working even I reinstalled
PgAgent but failed to get result.
Regards,
Abdul Rehman.
Oh!
I have got the mistake made by me. Actually I didn't start the PostgreSQL
Scheduling Agent - pgAgent service. Now its working fine.
I also have attached the complete document of my work for the sake of knowledge
share.
Regards,
Abdul Rehman.
Dear all,
After installing PgAgent I have successfully created a job for auto scheduled
backup. But it is not working. I have tried both method i.e. via .bat and via
SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
TOO MANY THANKS RAY!
I have got success in doing replication to an existing database. I did test on
a dummy databases. But I am sure that I can implement to live project.
Regards,
Abdul Rehman.
The
detail of my work is as under:
As I
mentioned earlier that platform is windows xp and using postgres 8.2 in which
Slony- I is included. And all databases are at localhost.
After
reading the document entitled “Replicating Your First Database” which is for
Linux I optimized the instr
Ok Ray!
I will send the detail of my work soon.
Thanks to All participants.
The link of the document, entitled "Replicating Your First Database" is as
under:
http://slony1.projects.postgresql.org/slony1-1.2.6/doc/adminguide/firstdb.html
reated via pgbench tool (accounts, history, branches, tellers).
whats going on!
--- On Tue, 10/28/08, Abdul Rahman <[EMAIL PROTECTED]> wrote:
From: Abdul Rahman <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] Replication with slony-I
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
ERAL] Replication with slony-I
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Date: Monday, October 27, 2008, 7:17 PM
On 27/10/2008 11:17, Abdul Rahman wrote:
> May any one support step by step procedure for the replication with
> slony-I in windows xp.
There's a pretty goo
May any one support step by step procedure for the replication with slony-I in
windows xp.
Dear all,
Due to personal reason (to celebrate EID) I will rejoin my work from
06-Oct-2008.
Regards,
Abdul Rehman
Glyn Astill.
--- On Tue, 9/30/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
From: Glyn Astill <[EMAIL PROTECTED]>
Subject: Re: [GENERAL] Replication using slony-I
To: pgsql-general@postgresql.org, [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Date: Tuesday, September 30, 2008, 1:36 PM
> F
to step # 13. I have Slony-I pgAdmin-III included
in postgresql-8.2 and the platform is WindowsXp. But here I am not
getting the "NewSubscription" option when do right click on
Subscription Set.
--- On Tue, 9/30/08, Abdul Rahman <[EMAIL PROTECTED]> wrote:
From: Abdul Rahman &
Thanks a lot for replying!
Here is complete information for consideration:
In order to perform replication. I am following the steps present in
http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html
and successfully reached to step # 13. I have Slon
I am not getting the "New Subscription" option when do right click on
subscription (0) on the master node.
Hi all,
I am following the steps present in this link:
http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html
But failed to complete step # 13. Here I am unable to get CREATE NEW
SUBSCRIPTION. Can any body guide me plz.
43 matches
Mail list logo
