Title: Meddelande
Hi,
Thanks for your help. I don't have Cygwin. Based on
your input I searched directories of all directories in my path. I found that a
GCC based compiler called WinAVR that I installed recently comes
with some TCL DLLs(and a Cygwin exe file). Anyway, renaming the
WinAVR
Peter Eisentraut wrote:
Tom Lane wrote:
Although I dislike last-minute fixes, I am strongly tempted to put in
the ignore-datallowconn-if-standalone change in all the releases we
are about to make.
I'm curious as to what the purpose of such a setting might be
(datallowconn = false)? Any functional
Hi Everybody,
I got this logged in my log file last night on my production
database while doing vacuumdb with analyze option , is this normal ?
does it affect the system anyway ? is there anyway to get rid of these
messages ?
2005-05-06 00:31:03 EDT%%% LOG: statistics buffer is full
2005-05
Pallav Kalva wrote:
Hi Everybody,
I got this logged in my log file last night on my production database
while doing vacuumdb with analyze option , is this normal ? does it
affect the system anyway ? is there anyway to get rid of these messages ?
2005-05-06 00:31:03 EDT%%% LOG: statistics buf
Title: View Relationship
Dear all,
I am new to database administration on postgreSQL.
I made a database using SQL commands.
It has 16 tables. I created foreign keys and also sequences.
I want to view the relationships between tables LIKE we view relationships in Access.
Reason bein
this applies to 7.x only:
raise PGSTAT_RECVBUFFERSZ in /src/include/pgstat.h (i.e. raise 1024 to
16384)
Performance drops will go away then (at least in my case here).
Regards
Bjoern
Pallav Kalva wrote:
Hi Everybody,
I got this logged in my log file last night on my production database
while
> If you are interested give me a call or we can go back and forth here.
>
Please do it here as I may have a similar situation with SQL Server soon and
would
like to learn from your experience.
Thanks,
mike
---(end of broadcast)---
TIP 6: Have you
I wrote a program to move my data it is a .net app.
If you are interested let me know and I can email It to you off list.
It does some conversions specific to my scenario but you could comment that
out (like making all my isdeleted fields Boolean (I had a mixture of stuff).
Takes 6 hours to move o
Hi,
I am reserving 2.1 GB of memory for postgres to use with SuSE linux 9.0
(SLES) in sysctl.conf.
I have configured postgres to use 1.9 GB of memory so it won't go over
the 2.1 cap (postgresql.conf).
I have a total of 4GB of memory. Somewhere I read to keep half of the
memory for other thi
On Fri, 2005-05-06 at 13:28, Kavan, Dan (IMS) wrote:
> Hi,
>
> I am reserving 2.1 GB of memory for postgres to use with SuSE linux 9.0
> (SLES) in sysctl.conf.
> I have configured postgres to use 1.9 GB of memory so it won't go over
> the 2.1 cap (postgresql.conf).
> I have a total of 4GB of
My first challange with restoring from dumps across different versions...
in pgsql 7.4.2:
I use pg_dumpall > $BACK_DIR/pgdumpall_test$TSTAMP.dmp.
I than copy the dump file over to another machine with pgsql 7.2.2.
I want to pg_restore just one database (i.e. wxsdb) without having to
manually
* Mauri Sahlberg <[EMAIL PROTECTED]> wrote:
> I have no control over the kernel version I am running. The server is
> located on virtual machine and the kernel version claims to be Linux
> claymountain.planeetta.com 2.4.20-021stab028.5.777-enterprise #1 SMP Tue
> Feb 22 17:44:46 MSK 2005 i686 i68
I was trying to compile a PostGreSQL 8.0.2 on Intel Linux for a PowerPC based
Linux.
Could you please let me know if 8.0.2 support PowerPC ? If it does, how do
I "configure" so it will build a binary to run on PowerPC_Linux ?
Thanks for any help.
Sam
---(end of br
I found a table pg_version_history in the public schema (which we don't
use). Does anyone know where this table comes from and what is it for?
Also I'd like to implement a code versioning for the functions. Is there
a package or a software to do this kind of things, so we can recover
from it a
I was trying to compile a PostGreSQL 8.0.2 on Intel Linux for a PowerPC based
Linux.
Could you please let me know if 8.0.2 support PowerPC ? If it does, how do
I "configure" so it will build a binary to run on PowerPC_Linux ?
Thanks for any help.
Sam
---(end of broa
Hi, I'm a postgres newbie trying to convert a small SQL Server database to
postgres 8.0 .
A typical table that i've created looks like this...
CREATE TABLE "Country"
(
"Id" int2 NOT NULL,
"Name" varchar(50) NOT NULL,
CONSTRAINT "PK_Country" PRIMARY KEY ("Id")
)
WITHOUT OIDS;
ALTER TABLE "Co
How can I backup a database (for restoration) when it is missing all of the
pg_* tables?
I've been bitten by the "SELinux silently ruins initdb" bug as reported by Tom
Lane: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=149237 and another
user: http://www.mail-archive.com/pgsql-bugs@postg
Hello,
I am very confused. I have a Debian server with PostGreSQL running. I have
everything installed and working.
Here is my wish list:
1. To do anything, I have to "su - postgres". This has no password. How do I
put a password on it. I have tried "passwd postgres wackypass" but it did
not wo
Hello ,
I have found the error.
I looked on an older SuSE-Version ( i think 9.1) where we also have a
postgres running. There the postgres-process is started with:
pg_ctl start -s -p $H -l $LOGFILE -D $DATADIR -o "\"$OPTIONS\"". On this
system the server is starting without problems.
On my new
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Daniel Browning <[EMAIL PROTECTED]> writes:
> I've been bitten by the "SELinux silently ruins initdb" bug as reported by Tom
> Lane: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=149237 and another
> user: http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg11191.html
While I have not
21 matches
Mail list logo
