Oliver Elphick wrote:
On Wed, 2002-11-20 at 10:14, Luis Sousa wrote:
Hi all,
I'm running postgresql 7.2.1 on a debian 3.0 machine and I want to do
some log rotation, but I'm having some problems. The configuration that
I'm using is:
In /etc/logrotate.d/postgres:
/var/log/postgres.log {
Hi,
I don't see command to rename database.
Yes, i can drop/create/restore database but is there any problems to
develop such command ?
Fouad Fezzi
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresq
On Thu, 2002-11-28 at 10:11, Luis Sousa wrote:
> >You should use copytruncate as a logrotate option, so that you will not
> >need to force the postmaster to close.
> >
> >This is my (working) setup:
> >
> >$ cat /etc/logrotate.d/postgresql
> >/var/log/postgres.log {
> > daily
> > ro
v7.3 beta
Warning: OpenDir: No such file or directory (errno 2) in
/usr/local/www/developer/betadir.php on line 4
Fatal error: Call to a member function on a non-object in
/usr/local/www/developer/betadir.php on line 7
Bidding the betas and RCs good bye ??
mallah
Date In 5 Bytes
Sir,
You can store date in 5 bytes.Reduce 3 bytes per record
Get the demo dll from www.geocities.com\kumar_jac\di5b.htm and test it.It
is very usefull for U.For more detail visit websit
by
On Mon, 2002-11-25 at 23:03, David Gilbert wrote:
>
> I'm on a bit of a mission to stamp out this misconception. In my
> testing, all but the most expensive hardware raid controllers are
> actually slower than FreeBSD's software RAID. I've done my tests with
> a variety of controllers with the sa
Dear Milist;
Please give me some advices and help.
How can i do
"select" the TABLE_1 on other
database DB_2,
but currently i'm connecting to on
DB_1.
ORACLE :
Current_DB_1 #> Select * From
DB_2.TABLE_1;
MS-SQL :
Current_DB_1 #> Select * From DB_2..TABLE_2;
PostGre :
Current_DB_1 #>
Hi all,
I'm using the libpq `PQgetvalue` function to get
specific results from my datase. Many of these
results are numeric types. Is there an internal
function in libpq that will convert the returned
string to an appropriate C-type based on the oid
values in src/include/catalog/pg_type.h?
Many
I seen that nobody reply to my post:
"Poor performance - Disk Usage"
I'm dreaming about that problems?
Is it a catch 22 ??
Ciao
Gaetano
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/d
You can't do cross-db queries directly. In 7.3, you can use schemas and
put them all in the same database, or use /contrib/dblink for cross-db
queries.
---
yudha wrote:
> Dear Milist;
> Please give me some advices and help
Javier Perez <[EMAIL PROTECTED]> writes:
> ...
> I work on MacOSX 10.2 and I installed PostgreSQL 7.2.2. In my case
> PostgreSQL was include in a CD pack with another open source called
> Grass.
AFAICT, the copy of Postgres you have has been modified by the makers of
that CD. I suggest you contac
Thank's for Milist's advices,
Dear Oliver Elphick
<[EMAIL PROTECTED]>,
You Wrote ;>You cannot read from another database. In 7.3,
you can have multiple>schemas in one database and the syntax for reading
a file from another>schema is:
> SELECT * FROM
schema.table...
On Fri, 2002-11-29 at 19:08, yudha wrote:
> Then how could i make it (SCHEMA)..??
> There are many tables split on 4 databases on my previous
> databases (MS-SQL Server). Could you give me more
> explanations about PostgreSQL-Schema. I've tried to search
> about schema on many url but i still d
Dear Milist and
Dear Oliver Elphick <[EMAIL PROTECTED]>
That's Cool. There's no better answer but
U.
Thank you very much. I will D/L PostgreSQL
7.3
Hope you don't cloy to give me another
Cools.
GOD Bless You All.
14 matches
Mail list logo
