Re: [ADMIN] Backup Scheduler...

2007-07-26 Thread Jayakumar_Mukundaraju
Dear Vishal/Ashish, Is there any related in Task Scheduler in my system.. The task scheduler is stopped in my system.. Thanks & Regards Jayakumar M From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thu 7/26/2007 4:32 PM To: Jayakumar_Mukundaraju; [EMAIL PR

[ADMIN] helpme!

2007-07-26 Thread pham thi thanh tra
dear, My laptop installed Windows Vista, the license version. When I installed postgreSQL8.2, it showed following message: "Unidentified pushlisher" happened when I registered Account. How must I do now? Thank you! Thanh Tra. _

[ADMIN] Can I retrieve NOTICE info from within a Stored Procedure?

2007-07-26 Thread Abraham, Danny
Thanks Danny Abraham [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] No create table

2007-07-26 Thread adey
Did your cammand fail, or did it work, but the user can still create tables? On 7/27/07, Anderson Alves de Albuquerque <[EMAIL PROTECTED]> wrote: I need to use a user that can not have permission to create table in one BD. I use revoke, I tray with "revoke all on database XXX to|from USERN

Re: [ADMIN] Question about Postgres

2007-07-26 Thread John Koller
NetComrade wrote: > I apologize for cross-posting, but I need some help w/o too many > advices RTFM :). After Oracle and MySQL, this becomes the third > product that I need to learn to some degree, and I need a few links > which would provide a 'quick tutorial' especially for folks with > Oracle b

[ADMIN] Question about Postgres

2007-07-26 Thread NetComrade
I apologize for cross-posting, but I need some help w/o too many advices RTFM :). After Oracle and MySQL, this becomes the third product that I need to learn to some degree, and I need a few links which would provide a 'quick tutorial' especially for folks with Oracle background like myself. Last t

[ADMIN] postgresql fails to release memory

2007-07-26 Thread Bolotov Pavel
Hi When postgresql releases connections ? i use postgresql on ubuntu server, run pg_dump mydb > db.out psql -d database -f db.out then run top and see more postgres processes. more pg_dump commands i run, less memory left Thanks Pavel. _

[ADMIN] No create table

2007-07-26 Thread Anderson Alves de Albuquerque
I need to use a user that can not have permission to create table in one BD. I use revoke, I tray with "revoke all on database XXX to|from USERNAME;", but I don't have success. Could someone help me? With revoke I only limit access in tables.

Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4

2007-07-26 Thread PostgreSQL Admin
I hate to sound like a --- but did you read the README on starting the server? You start the server by using the postmaster command: /path/to/postmaster -D /path/to/data look at the postgresql manual - it's all there. J ---(end of broadcast)-

Re: [ADMIN] Backup Scheduler...

2007-07-26 Thread Richard Broersma Jr
--- Jayakumar_Mukundaraju <[EMAIL PROTECTED]> wrote: > Dear Visha/Ashish, > > My batch file is content of below script. > @echo off > "C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f > D:\test\test1.sql -F p -C -d -D > postgres > @echo on > The solution that I use is found on

Re: [ADMIN] Backup Scheduler...

2007-07-26 Thread Jayakumar_Mukundaraju
I didn't seen any error in event log... I set the schedule in 4.40pm today.. In 4.41 in my system the cursor action is changed to some process is going.. Thanks & Regards Jayakumar M From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thu 7/26/2007 4:32 PM T

Re: [ADMIN] Backup Scheduler...

2007-07-26 Thread Vishal Arora
Are you sure you have included "D:\test\test1.bat" within double quotes and selected the kind as batch in job. Can you see event log and send it to me, what is the exact error pgAgent service is giving. - Vishal From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]> To: "Jayakumar_Mukundaraju"

Re: [ADMIN] Backup Scheduler...

2007-07-26 Thread Jayakumar_Mukundaraju
Dear Vishal/Ashish Yes i did same as u said... I created one job and i gave the schedule time .30mnts and date also, and i create definition in step tab D:\test\test1.bat.. If i given a command in command prompt C:\Program Files\Postgresql\8.2\bin\ Net start pgAgent .. I get the result is t

Re: [ADMIN] Backup Scheduler...

2007-07-26 Thread Jayakumar_Mukundaraju
Dear Vishal/Ashish, Waiting for your reply From: Jayakumar_Mukundaraju Sent: Thu 7/26/2007 9:45 AM To: Vishal Arora; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Backup Scheduler... Dear Visha/Ashish, My batch file is content of bel