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
I checked in control pannelAdministrative toolservices... the postgreSQL
Scheduling Agent service is running...
I didn't understand how my job is not running... Give me the solution
Jayakumar M
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Fri
Anderson Alves de Albuquerque 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 USERNAME;,
but I don't have success.
Could someone help me?
You have to revoke permissions from the _schema_, not
Hi, Guys,
Does any one here run Aqua Data Studio to produce database
documentation? My user really likes pretty pictures so I'd like to
get this resolved, if possible. I'm having a rather strange problem
with it which quite possibly relates to my postgres configuration
files. I'm in
When I use revoke that you send, I revoke permission in all database. Is
there possible I use this revoke in one BD only?
On 7/27/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Anderson Alves de Albuquerque wrote:
I need to use a user that can not have permission to create table in one
BD.
--- George Wilk [EMAIL PROTECTED] wrote:
Is there a reliable way of verifying version of the database by looking at
the PGDATA directory?
Does the file PG_VERSION not tell what you need?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
Is there a reliable way of verifying version of the database by looking at
the PGDATA directory?
Let me explain why this is important in our case. Originally, our product
utilized version 8.1 of Postgres. We have since moved on to version 8.2.
Our existing customer base will need to be
I try with revoke all on schema PUBLIC FROM PUBLIC;, but after give GRANT
SELECT user can't use SELECT. When I use revoke CREATE on schema PUBLIC
FROM PUBLIC; and give GRANT SELECT user can use SELECT.
On 7/27/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
Anderson Alves de Albuquerque wrote:
Hi folks,
My postgres (v 7.1.4, I think) did not come up upon reboot.
I have tried to use startup script called postgresql in
/etc/rc.d/init.d directory, but it reports FATAL when I
try to stop postmaster.
The most recent log file in /pgsql/data/pg_log reads:
LOG: database system was
On 26 Jul, 18:51, NetComrade [EMAIL PROTECTED] 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
[snip]
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
remove NSPAM to email
Contact me offline.
Has anyone started, worked on, drafted and/or completed a STIG for
PostgreSQL?
Thanks,
Shawny Marsden
PM/QA
acusoft
11869 High Tech Avenue
Orlando, Florida 32817
image001.gif
On Fri, Jul 27, 2007 at 9:49 AM, in message
[EMAIL PROTECTED], George Wilk
[EMAIL PROTECTED] wrote:
Is there a reliable way of verifying version of the database by looking at
the PGDATA directory?
Could you use the first couple lines of output from pg_controldata?
-Kevin
Yes, it does. However, in one test case after running dump, restoring, and
upgrading to 8.2 the PG_VERSION was still showing 8.1. This could have been
a result of us monkeying around, but still I wasn't sure when the PG_VERSION
was being updated, and whether it provided reliable source of
On 7/27/07, Tena Sakai [EMAIL PROTECTED] wrote:
Hi folks,
My postgres (v 7.1.4, I think) did not come up upon reboot.
I have tried to use startup script called postgresql in
/etc/rc.d/init.d directory, but it reports FATAL when I
try to stop postmaster.
The most recent log file in
Hello all
I make a lot of tests with trigger and first problem the function
_PG_fini are never called it is a bug ?.
This is a big problem for me because I want to cleanup the data managed
by my trigger.
second problem I cannot detect from a trigger the kind of call (row or
transaction) I
On Jul 27, 2007, at 10:05 AM, Carol Walter wrote:
I can go into Aqua Data Studio to the registered student server and
ADS will draw pretty ERD's with appropriate relationships, so long
as the table constraints are properly designed. When I try to do
the same thing with the other
On Fri, 27 Jul 2007, De Leeuw Guy wrote:
I make a lot of tests with trigger and first problem the function
_PG_fini are never called it is a bug ?.
_PG_fini is called when the file is unloaded, but not at process end,
according to the documentation, so I don't think it does what you want.
Hi,
I have looked at documentation on the web. For example,
http://www.postgresql.org/docs/8.2/interactive/index.html.
Is there any place I can get it in pdf (or some other printer
friendly) format? I thought I had seen it on my distribution,
but I cannot locate it.
Thank you.
Tena Sakai
On 7/27/07, Tena Sakai [EMAIL PROTECTED] wrote:
My postgres (v 7.1.4, I think) did not come up upon reboot.
I have tried to use startup script called postgresql in
/etc/rc.d/init.d directory, but it reports FATAL when I
try to stop postmaster.
PostgreSQL versions that old WILL EAT YOUR
Hi Scott,
It recovered. Amazing, although I don't know
why it got to that (broken) state. I am fairly
new at this job and I have never met my predecessor,
so that I don't have much sense of history. But
I have a new machine on which I have installed
8.2.4 and the project to move the data is
NetComrade wrote:
On Thu, 26 Jul 2007 21:02:58 -0500, John Koller
[EMAIL PROTECTED] wrote:
NetComrade wrote:
-bash-3.00$ export PGPORT=5733
-bash-3.00$ psql -l
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
21 matches
Mail list logo