Is it possible to run PostgreSQL in read-only mode?
For executing some maintenance procedures, I need to move database in
and out of the read-only mode
Is it possbile in PostgreSQl and if yes, how would I do it
Thanks in advance
---(end of broadcast)
Hi all...i'm trying to make a view i created in postgres editable...
I was trying with a rule like this one:
create rule test_rl as on
insert to my_view do instead
insert to my_real_table;
but it doesn't seem to work...
Basically i need that the whole view must be editable..
Thanks for your sug
Nicolas Kowalski wrote:
>
> Hello.
>
> We use PostgreSQL 7.1.2 on Debian GNU/Linux as our Intranet database. I
> am currently working on a small mailing-lists management application. I
> would like to enforce table access permissions depending on the current
> username :
>
> - if the current
Hello all,
before you start reading, have in mind that this is not post to advertise
one db over another, I just want to know what happens, that's why I did
the comparisons with other db.
to the point:
This is my table:
Table "table1"
Attribute |Type | Modifier
--
We have a weird problem.
When we try to update a table, we get this message
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Dear all,
I upgraded my PostgreSQL installation using Redhat's RPM.
I believe the start up script in /etc/rc.d/init.d has not
been changed.
The postmaster seems to be running smoothly (psql session
works fine).
However when I try to connect to the database via Apache
with PHP, I get an errormessa
Hi,
Can I write a function that can write the output to the OS(Linux OS) file.
If there is a way to do it in Postgresql It would be great.
We are using Postgresql 7.1 running in Linux Redhat 7.1.
Thanks in Advance.
Vijay
---(end of broadcast)
Hi every one
I have a big problem, I think it's a syntaxical one, but can't solve it,
please help !
What I am trying to do is a simple function who updates data in a table and
if no row was updated, then add a new one with the specified parameters.
And i would like to do it using SQL and anyth
Some time ago I posted to comp.databases a list of requirements which
IMHO any RDBMS product must meet to be generally useful in commercial
applications.
I got some responses back regarding Postgresql but a lot of
improvements have since been made, so I am reposting the original list
of questions
I'm sure I'm doing something stupid, but this is driving me nuts...
This is the first stored procedure I've ever written in my life.
I have a database calle
jags_content
jags_content has a table in jags_content called
update_flag
update_flag has a column of type timestamp called
content
S
On Thu, 5 Jul 2001, Tom Lane wrote:
> Ryan Mahoney <[EMAIL PROTECTED]> writes:
> > Re: killing a process from browser, I don't think what you're trying to do
> > is really possible.
>
> If the client-side code were programmed to send a Cancel request to the
> backend when the user loses interes
Version: Postgres 7.1.2
A product we are developing requires frequent loading
of a large number of rows into a table. We are using
the "copy file" command, but with WAL we are effectively
doubling the amount of disk writing we are doing.
After the rows are loaded we do a "create index".
Is the
On Mon, 2 Jul 2001 15:04:41 + (UTC), Richard Huxton <[EMAIL PROTECTED]>:
> There is a brief description of PG's MVCC in Linux Gazette that people might
> find of interest. Written by Joseph Mitchell of Great Bridge
>
> http://www.linuxgazette.com/issue68/mitchell.html
>
Thank you. That is
Hello,
We have been putting a lot of work into Part IV of the book.
We would appreciate some fresh feedback on the chapters 9 and 10.
As always, the link:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Thanks!
OpenDocs
---(end of broadcast)--
Hello,
Try WinSQL at http://www.indus-soft.com/winsql. It is absolutely FREE and does
not expire. It is only one file and does not come with any bulky DLLs. If you
don't like it, simply delete the file from your harddisk.
Features:
--
* Connect to any database through ODBC
* Syntax Highl
Hello,
I'm looking for people in Belgium, who have any experience in working with
Databases, so we can exchange views and experiences. Do you know such people
(or maybe it's you), please contact me at [EMAIL PROTECTED] .
Greetings
Nico Vaes
---(end of broadcast)---
Patrick Macdonald <[EMAIL PROTECTED]> wrote:
>
>I would like to take this opportunity to introduce myself
>and the Red Hat Database development team to the PostgreSQL
>community. We are pure engineering team (development,
>test and technical writing) based at the Red Hat Canada
>engineering of
If PostgreSQL is run on a system that has a file size limit (2 gig?), where
might cause us to hit the limit?
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
---(end of broadcast)---
TIP 3: if posting/readi
Hi there - we've hit a bit of a brick wall with this and I was
wondering if someone could help us out. Our MS-SQL code is this :
SELECT "Site"."Name" as "SiteName", "Site"."Description" as
"SiteDescription",
"Site"."DefaultStyle", "Site"."PageWidth",
"Site"."Tel", "Site"."Fax", "Site"."Email",
I downloaded postgresql RPM 7.1.2 from postgresql.org, binary version built
for Redhat 6.2.
When installing the package rpm reports a dependency error, not finding
libssl.so.0 & libcrypto.so.0.
where can i find these two libraries? None of packages in RH 6.2 CD contains
that.
thank you.
---
[EMAIL PROTECTED] writes:
> On the other end of the spectrum there are many addresses with only one
> entry. When I use one of these addresses in the WHERE clause it takes
> just as long as the address with 150k rows. If the sequential scan is
> better for 150k rows out of 800k rows, what abo
On Tue, Jul 10, 2001 at 04:47:49PM +0200, Peter Eisentraut wrote:
> Martijn van Oosterhout writes:
>
> > Well, getting closer. Maybe I should start version numbering the patches?
>
> For one thing, you might want to post them to pgsql-patches instead. And
> you should start generating the patch
> 1. I find about 50% database storage overhead in this case. That's not
completely silly, considering this is structured data, but seems a little
high. I don't know >the internal structures well enough to really see
what's happening.
Hmm, the PG docs say to expect data stored in the database t
Hello:
I'm not able to get a proper encoding with TCL 8.3
and Postgres 7.1.2_2.
I've tried setting the DB enconding to UNICODE and still
doesn't work.
If I use TCL 8.0 the chars get stored properly on the DB but
are not shown correctly on PgAccess (they are shown in hexa)
On the other end of the spectrum there are many addresses with only one
entry. When I use one of these addresses in the WHERE clause it takes
just as long as the address with 150k rows. If the sequential scan is
better for 150k rows out of 800k rows, what about 1 out of 800k? It
seems that
Martijn van Oosterhout writes:
> Well, getting closer. Maybe I should start version numbering the patches?
For one thing, you might want to post them to pgsql-patches instead. And
you should start generating the patches against the 7.2devel sources
because I already suspect yours generating con
"Woo Weng Kong" <[EMAIL PROTECTED]> writes:
> Would appreciate a lot if anyone could tell me if there is any
> disadvantage/performance issue in using PostgeSQL on windows.
I wouldn't recommend such a setup for a production server; the
reliability is just not up to par. (Use Postgres on almost a
On Tue, Jul 10, 2001 at 07:44:34AM -0400, Adam Manock wrote:
: Hi,
:
: I am about to put a 7.1.2 server into production on RedHat 7.1
: The server will be dedicated to PostgreSQL, running a bare minimum of
: additional services.
: If anyone has already tuned the configurable parameters on a dual
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> To actually be able to use ExecInsertIndexTuples, you need to create an
> EState, a ResultRelInfo and put each tuple in a TupleSlot for a while. Does
> it sound like I'm on the right track? That's quite a few changes.
Right. I'd recommend copy
Am Dienstag, 10. Juli 2001 13:44 schrieb Adam Manock:
> Hi,
>
> I am about to put a 7.1.2 server into production on RedHat 7.1
> The server will be dedicated to PostgreSQL, running a bare minimum of
> additional services.
> If anyone has already tuned the configurable parameters on a dual PIII w/
hi,
is there a editor out there with syntax highlighting for
PL/PGSQL. preferable Vim oder Xemacs.
I am using Xemacs with sql-mode, but this is only for
generic SQL AFAIK.
thanks a lot for any hint!
markus
--
Markus Jais
http://www.mjais.de
[EMAIL PROTECTED]
The road goes ever on and on - Bilbo
> Is there a known problem with HASH type index in PostgreSQL 7.1.2
> 4PGDG on Red Hat Linux 7.1 (2.4.2 kernel)? I can't find a lot of
> documentation, but this is what I observe:
Tom Lane has mentioned several times that index types other than BTREE
have suffered some bit-rot over the past few
On Mon, Jul 09, 2001 at 08:22:43PM -0400, Tom Lane wrote:
> AFAIR, cnfify doesn't modify its inputs. But watch out for the
> difference between explicit and implicit ANDing.
OK, I'm pretty sure I got it right now.
> In practice, I seem to recall that VACUUM is broken for partial indexes
> anywa
Hi There,
1. We had to make the following changes to the configure script, which
was not otherwise recognizing the presence of some libraries.
The modifications in the configure script are the following
A. Removal of -Wl from LDFLAGS
B. Addition of an empty main function ( int main() { ; retu
Hi,
I am about to put a 7.1.2 server into production on RedHat 7.1
The server will be dedicated to PostgreSQL, running a bare minimum of
additional services.
If anyone has already tuned the configurable parameters on a dual PIII w/
1GB RAM then I
will have a great place to start for my performa
35 matches
Mail list logo
