On Mon, 6 Nov 2000, Steve Wolfe wrote:
>It seems like it's not something that needs to be done in real-time. Am
> I correct? If so, then soing a pg_dumpall, gzip it up, and restore on the
> other server is probably the way to go.
I developed a realy not time critical Web-Site (small project
Hi,
Does anyone know what the postgresql option deadlock_timeout does? I
haven't been able to find any good docs. The config file
(/etc/postgresql/pg_options) just says its how long to wait before deciding
that there is a deadlock, but does this refer to idle connections or
situations wh
Thats very true. FreeBSD is a little smarter, and actualy kills a runaway
process if it allocates more memory than is available. It of course tries to
page things in and out of swap first, hoping the high memory condition will
soon resolve its self. FreeBSD is also one of the only OSes I've
Dmitriy Agafonov <[EMAIL PROTECTED]> writes:
> Stupid question - what's the uniqueness scope of a cursor name. Is it
> connection (as, I assume, it's supposed to be)
Yup, per-connection (actually per-transaction, since cursors don't
survive across transactions).
regards,
> How would you go about mirroring a database server such that if all updates
> to the main database are also made to the backup?
Try usogres. It works pretty well for me (PostgreSQL 7.0.2).
--
Tatsuo Ishii
>Subject: [ANNOUNCE] usogres-0.0.5 released
>From: Hosokawa Tetsuichi <[EMAIL PROTECTED]>
How would you go about mirroring a database server such that if all updates
to the main database are also made to the backup?
Mark
This might be the stupidest idea ever, but it seems logical to me, so
tell me what you think:
What if I use the TCP/IP connection to connect the two databases - Then
I SELECT * INTO a temporary table on the remote server. Once that is
completed (and any relational tables), I drop the table on the
hello,
has anyone converted files from filemaker to postgres? I'm figuring I'll
just export everything into tabbed text files and then use the perl
extensions to parse it out into INSERT queries. If anyone has any experience
(or code!) to share on this process, it would be great to hear about it.
Anything that can be done without waiting for erserver? I need to find a
solution asap. Any ideas at all would be great. I don't even know where
to really begin. Thanks,
Joe
ok, so i know how to use GRANT/REVOKE to assign permission levels on tables.
however, it eludes me on how to do it on a database level.
i poked about in the manuals and nothing jumped out and said "here's how
you do it".
for example, i have a database called "samples".
in "samples", i have va
Stupid question - what's the uniqueness scope of a cursor name. Is it
connection (as, I assume, it's supposed to be) or is it something else
(database, server, client, ...) ? I am accessing the database using C
API thru a set of C++ wrappers, which I wrote myself (the standard ones
weren't satisf
Check this out:
http://www.erserver.com/
I don't know the status of this project, but I'm certainly looking
forward to try it.
Poul L. Christiansen
[EMAIL PROTECTED] wrote:
>
> Is there a way to synchronize data between postgresql on a local machine
> and postgresql on a remote web server? May
Hi!
I have installed postdrv.exe on a W98 machine ( it seems to be for 6.5
version ) and it works against the postgresql 7.0 under Linux.
I have linked some tables from MsAccess 2000 and the problem is that
sometimes when I try to update a row from MsAccess it does not let me do
it. It say
Is there a way to synchronize data between postgresql on a local machine
and postgresql on a remote web server? Maybe use the TCP/IP Connection
with SSH somehow? Anyone done this or have any good ideas? Thanks a lot,
Joe
bf2=# create function foo (varchar, varchar) returns varchar as '
begin
return $1;
end;
' language 'plpgsql';
bf2'# bf2'# bf2'# bf2'# CREATE
bf2=# bf2=# select foo('asdf', null) from dual;
foo
-
(1 row)
Even though the function foo never references the null, apparently postgres
thinks,
Hi!
when i do initd --pglib=$HOME/lib --pgdata=$HOME/data
after vacuuming template1 i get some errors,and does'nt create pg_user
table neither pg_views etc..
can anyone help me?
Tara Pierkowski <[EMAIL PROTECTED]> writes:
> In essence, what I have found is that if I execute a somewhat lengthy query
> and dump the output to the screen I get a result set that is different than
> if I execute the exact same query but use the query as the source for an
> insert command.
You
Hello.
I've come across something that seems like it may be a bug. I was wondering
if someone could either confirm that this was the case or explain to me the
error of my ways. ;-)
In essence, what I have found is that if I execute a somewhat lengthy query
and dump the output to the screen I get
Hi,
is there a way to set up an order in which triggers are fired up on same
table?
tia
mazek
Marcin Mazurek
--
Kierownik Działu Systemowego
MULTINET SA o/Poznan
http://www.multinet.pl/
On Sun, Nov 05, 2000 at 10:41:12PM -0800, Michael Miyabara-McCaskey wrote:
> Out of curiosity, if I were using something else besides "psql" would this
> have still been a problem?
Yes. The library interface in libpq will pull the entire record set
into memory unless you use cursors.
--
Bruce G
>> Anyway, I crashed my system the other day when I did a "select *" from
>> one
>> of my large tables (about 5.5gb in size).
>
> Well It takes abit more than that to actually crash the system. Can
>you give more details? What _exactly_ happened? Did it hang? Kernel
>panicked? So
we just update from a 6.5 to a 7.0 version and we made a dumpall and we saved all
files too.
Restoring the data stored with dumpall didnt bring back the blobs again.
How can I restore the blobs out of the pure filedump again ?
thanks,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +
22 matches
Mail list logo
