Bruce Momjian wrote:
> ALTER TABLE ... OWNER in 7.1.
>
> > I must be missing this somewhere in the documentation. How can I change
> > the owner of a table?
> >
> > Thanks.
> > -Tony
Sorry. I should have specified that I still using 7.0.3. Do I have to go into
pg_table or something?
-Tony
--
I must be missing this somewhere in the documentation. How can I change
the owner of a table?
Thanks.
-Tony
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED
If I have a process which is inserting/updating tuples and run a vacuum
while that process is going, will the vacuum wait for the process to
finish? Or, will I have a problem with the db? How about the other way:
doing a insert/update while a vacuum is running?
Thanks.
-Tony
--
I may have a chance to upgrade the hardware for our db server in a few
months time. Are there any advantages to using a dual processor system
for Postgres?
-Tony Reina
We have three databases for our scientific research and are getting
close to filling our 12 Gig partition. My boss thinks that just getting
a really big (i.e. > 30 Gig) SCSI drive will be cheaper and should do
nicely. Currently, we only have 4 people accessing the database and
usually only have 1-
Alfred Perlstein wrote:
> You need to read your shell's manpage, try:
>
> nohup postmaster -i >& pgserver.log &
>
This worked. The output still gets directed to stdout but is also logged
into the file.
Thanks.
-Tony
I'm trying to start the postmaster exactly how it is written in the
installation instructions:
nohup postmaster -i > pgserver.log 2>&1 &
However, RedHat Linux 6.1 gives me an 'Ambiguous output redirect '
error. This is probably because I'm using TCSH instead of BASH.
Is there a way that I can r
I have Postgres 7.0.2 installed on my RedHat Linux 6.0 system, but
realized today that I hadn't built any of the manual pages or
documentation during that installation. I downloaded 7.0.2 again, did a
configure, and then followed the instruction to do 'gmake install' in
the src/postgresql-7.0.2/d
Should pg_hba.conf be owned by root or by postgres? I'd think that root
would be a little more secure.
-Tony
> What I would like to know. has anybody working databases using
PostgreSQL
> with sizes more than 500 MByte and is happy with it ??? We consider it
> using for research projects starting in autumn, but we would like to
> know, how it behaves with large databases ?
Marten,
We have a 2 Gig d
> Starting postgresql service: /usr/bin/postmaster does not find the
database
> system. Expected to find it in the PGDATA directory "/var/lib/pgsql",
but unable
> to open file with pathname "/var/lib/pgsql/base/template1/pg_class".
> No data directory -- can't proceed.
> postmaster []
Matt,
Philippe Martin wrote:
> I have the same problem on IRIX 6.5.1 as Tobias Lehtipalo
> (Subject: v6.4.2 compiler problems cont'd, Date: Sat, 6 Feb 1999),
> that is:
> gcc -I../../../include -I../../../backend-U_NO_XOPEN4 -Wall
>-Wmissing-prototypes -O2 -I../.. -c heaptuple.c -o heaptupl
I have been trying to re-compile PostgreSQL 6.4.2 on my IRIX 6.5.3
machine so that I can use the readline option. I installed GNU readline
4.0 on my IRIX. It created a new directory called
/usr/local/include/readline which contains the following files:
> ls
---
I read in the archives that I need the GNU readline in order for psql to
recognize the up and down arrows (i.e. the history of the last command).
Does anybody know if PostgreSQL links this when the program is first
compiled? That is, do I have to re-install Postgres 6.4.2 in order to
have readlin
Jeremy,
I have Postgres 6.4.2 running on RedHat 5.2 with the new 2.2.1 Linux
kernel on a 400 MHz PII with 512 Meg RAM and an 18 Gig SCSI drive. I
have had problems with Postgres being pretty slow because my database is
fairly large (almost 1 Gig). I seemed to have finally solved my speed
pro
I recently updated my OS to RedHat 5.2 with the 2.2 Kernel. I was last
using Postgres 6.4.2 with my database. I re-installed Postgres 6.4.2
into the new operating system and tried to copy the contents of the
database directory over to the newly installed directory.
I am able to select and update
That makes sense. Is there a way that is less drastic than dumping,
re-initdb, and reloading the database? It would probably take a day or
two to do this. Does anybody know if I can fix the catalog in another
way?
-Tony
Jan Wieck wrote:
>
> That behaviour reminds me of a similar situati
I've had trouble in the past with the vacuum command taking a long time
to complete. This past vacuum went for 5 days before I CTRL-C'd it. I'm
wondering if there is a bug.
I have PostgreSQL 6.3.2 on a Red Hat 5.1 system (PII/400 MHz, 256 Meg
RAM, 512 Meg Swap, 18 Gig Hard Ultra-wide SCSI Drive).
Thanks Hui,
SHMMAX was set to 0x200 in that .h file. So it looks as though the
system wasn't allowing anything to allocated more than 32 meg of shared
memory (as I found out with the -B option on the postmaster). I haven't
had a chance to go through re-building the kernel. Our IT guy
I had no trouble installing Postgres 6.4 onto my RH Linux 5.1 box.
However, I can't seem to get past the configure point for my SGI's
running IRIX 6.5.
I run configure --with-template=irix5 and get the error "can't create
executables with gcc". I am pretty sure that the gcc on our machine is
for
I have the new Postgres 6.4 installed. My system has 256 Meg of RAM with
512 Meg of swap space (PII/400 MHz; RH Linux 5.1). I am trying to
maximize the number of shared memory buffers for the postmaster. It
seems that if I get over 28 megs (-B3500), that the postmaster won't
run:
nohup postmast
Marc,
I'm running PostgreSQL v. 6.3.2. No I don't want to disable fsync just
in case someone stops a process midstream (which has happened before-- I
figure it could screw up the db). So maybe it is those "memory leaks"
that you've suggested. I'll try closing and re-connecting to
--
( @@ )
oOO*(__)*OOo///
////
// G. Anthony Reina, MD //
// The Neurosciences Institute//
// 10640 John Jay Hopkins Drive
23 matches
Mail list logo
