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
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 und
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 Y
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
[EMAI
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.
>
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 suggest
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 instance,
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
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 interrupte
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 version
>>> 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
--
--- 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)
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
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
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 upgrad
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
<>
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 an
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 offl
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 _sche
I checked in control pannel>>Administrative tool>>services... 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
20 matches
Mail list logo