Sure, see the section in the manual titled "Managing Disk Space".
---
Ravikant Mohite wrote:
> Hi
> Can Anybody tell me how to check the DB Size of PostgreSQL 7.3.4 ?
>
> Regards
> Ravikant
--
Bruce Momjian
On Fri, Nov 07, 2003 at 15:47:50 -0500,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> I am trying to revoke the create table privilege from a user in a
> database.
>
> I have revoked create on database and on the public schema, yet I can
> still create table as that user. what else do I n
"John Pagakis" <[EMAIL PROTECTED]> writes:
> Once upon a time a friend of mine and I wrote a document that I believe is
> still on techdocs: "Compensating for Unimplemented Features in PostgreSQL
> 7.1".
> Therein was included a perl script (that really *DID* work when we published
> it) that was i
Thats the thing, I have no idea how I got into this. I was cutting and pasting the view from one database to another. Did a refresh, it didn't show, I pasted again, it allowed it and then all hell broke lose.
This was in pg_admin III.
Thanks for the fix, I will try, I can afford to lose it
* Christopher Browne ([EMAIL PROTECTED]) wrote:
> On one of our test servers, I set "fsync=false", and a test load's
> load time dropped from about 90 minutes to 3 minutes. (It was REALLY
> update heavy, with huge numbers of tiny transactions.)
>
> Which is, yes, quite spectacularly faster. But
I am trying to revoke the create table privilege from a user in a
database.
I have revoked create on database and on the public schema, yet I can
still create table as that user. what else do I need to do?
thanks,
signature
Jim
Bagley
Database Manager
Trader Electronic Media
(757) 3
Can you just use the SQL logging and read that file afterwords?
/djb
- Original Message -
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, November 07, 2003 14:59
Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve s
Once upon a time a friend of mine and I wrote a document that I believe is
still on techdocs: "Compensating for Unimplemented Features in PostgreSQL
7.1".
Therein was included a perl script (that really *DID* work when we published
it) that was intended to script out the foreign key constraints of
We have had the same problems/experiense here.
What we have done to solve the problem was to write a simple application
that runs as service - it runs before CygWin Ipc Daemon and checks for
existing .pid file. If it exists - delete it. You should register CygWin
service to be dependent on this new
[EMAIL PROTECTED] (Jeff) writes:
> On 06 Nov 2003 15:21:03 +0100
> Marek Florianczyk <[EMAIL PROTECTED]> wrote:
>
>> fsync = false
>
> HOLD THE BOAT THERE BATMAN!
>
> I would *STRONGLY* advise not running with fsync=false in production as
> PG _CANNOT_ guaruntee data consistancy
scott.marlowe wrote:
Note that if you're on an IDE drive and you haven't disabled the write
cache, you may as well turn off fsync as well, as it's just getting in the
way and doing nothing, i.e. the IDE drives are already lying about fsync
so why bother.
What about Serial ATA?
-
Hi
Can Anybody tell me how to check
the DB Size of PostgreSQL 7.3.4 ?
Regards
Ravikant
Hi,
I got this little problem creating users:
I want to connect to my db with a new user and I must create it like if he
was a superuser, otherwise I can not conncet to my database.
Could some body help me
Thanks a lot
Alvaro
---(end of broadcast)---
I'm trying to build erserver_v1.2 on a SuSE 8.2 server.
I've got Sun's j2sdk1.4.2_02 and the following env variables set:
LESSKEY=/etc/lesskey.bin
INFODIR=/usr/local/info:/usr/share/info:/usr/info
MANPATH=/usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome2/man:/opt/gnome/man
HOSTNAME=linux
X
I am receiving the following error from Postgres 7.3.3 on Linux
Bogus attribute number 24 for vs_actfreighservices (a view).
This error is preventing me from doing a dump on the database's and I cannot delete the view that has the problem.
Is there a way I can work around this? I can access
Hi,
Christopher Browne wrote, On 11/6/2003 4:40 PM:
[EMAIL PROTECTED] (Jeff) writes:
On 06 Nov 2003 15:21:03 +0100
Marek Florianczyk <[EMAIL PROTECTED]> wrote:
fsync = false
HOLD THE BOAT THERE BATMAN!
I would *STRONGLY* advise not running with fsync=false in production as
PG
On Fri, 7 Nov 2003, Juan Miguel wrote:
> Ok, the web works fine. The problem is my Zone Alarm Pro Firewall. I can
> browse the most web pages, but when I connect to www.postgresql.org, the
> download stops. Shuting down the firewall, the web is already accesible.
Any way of determining why?
>
Ok, the web works fine. The problem is my Zone Alarm Pro Firewall. I can
browse the most web pages, but when I connect to www.postgresql.org, the
download stops. Shuting down the firewall, the web is already accesible.
Thanks.
works fine for me from here, and they are all on the same set of ser
Steven Tower <[EMAIL PROTECTED]> writes:
> I am receiving the following error from Postgres 7.3.3 on Linux
> Bogus attribute number 24 for vs_actfreighservices (a view).
Hm, can you tell us how you got into this fix? That shouldn't happen
AFAICS.
As far as getting out of the problem is concerned
I am receiving the following error from Postgres 7.3.3 on Linux
Bogus attribute number 24 for vs_actfreighservices (a view).
This error is preventing me from doing a dump on the database's and I cannot delete the view that has the problem.
Is there a way I can work around this? I can access
20 matches
Mail list logo
