You could add this into whatever script starts up pg_ctl, but only if
you decide to use PostgreSQL rather than "Postgre".
> Could any one tell me how can I implement this in Postgre. Is there
> any concept like "Scheduled Jobs" in Postgre. If so pls. provide me
> with related informations or the l
"Mark Travis" <[EMAIL PROTECTED]> writes:
> I've been trying to get postgres to start on my machine for a few days (on
> and off) and have not been successful in understanding why it will not
> start.
The pre-8.0 RPMs have a bad habit of sending the postmaster log to
/dev/null :-(. You could edit
System: 1.5 GB memory; 160 GB hard drive with 140 GB free (plenty of space
in the database directories); 1.5 Mhz AMD Athlon processor.
- Fedora Core 3 with all fixes applied
- Postgres 7.4 as supplied by up2date (RedHat network)
I've been trying to get postgres to start on my mach
On Wed, 2005-03-16 at 11:55, Chris Hoover wrote:
> Tom,
>
> Thanks so much for the possible reason the vacuum fulls are not running.
>
> But, how about the first question. When you run a vacuum , who
> has access to the freed tuples? (only the table, the db, or the entire
> cluster)???
the t
Tom,
Thanks so much for the possible reason the vacuum fulls are not running.
But, how about the first question. When you run a vacuum , who
has access to the freed tuples? (only the table, the db, or the entire
cluster)???
Thanks,
Chris
---(end of broadcast)---
Dnia Åroda, 16 marca 2005 15:05, Scott Marlowe napisaÅ:
> On Wed, 2005-03-16 at 07:46, Marcin Giedz wrote:
> > Dnia wtorek, 15 marca 2005 18:00, Scott Marlowe napisaÅ:
> >
> > OK now I know I mys query lasts so long:
> >
> > SELECT DISTINCT t1.Id, t1.IdTypNazwa, t1.IdFirma, t1.Nazwa,
> > t1.NazwaAs
You can easily test yourself:
test=# \d t1
Table "public.t1"
Column | Type| Modifiers
+---+---
f1 | integer | not null
f2 | character varying |
Indexes: t1_pkey primary key btree (f1)
test=# \d t2
Table "public.t2
Hello,
I wonder if postgres autocreates an index on foreign or primary key fields.
For example:
create table t1 (
f1 integer,
f2 varchar,
primary key (f1));
create table t2 (
f1 integer,
f2 integer,
primary key (f1),
foreign key (f2) references t1(f1)
);
In this sample, "t1" has a
On Mar 16, 2005, at 8:09 AM, Wes Williams wrote:
phpPgAdmin was as exhaustive as phpMyAdmin,
more users might be FIRST inclined to start with Postgres
I'm not familiar with phpMyAdmin. Could you give a few examples of
things it has that phpPgAdmin is lacking?
Thanks,
John DeSoi, Ph.D.
http://pge
Ah, my Sys. Admin. tells me this is the easiest way and it won't
restart the database instance:
kill -HUP postmaster_pid
-david
On Wed, 16 Mar 2005 15:40:35 +0100, Miroslav Åulc
<[EMAIL PROTECTED]> wrote:
> David Wagoner wrote:
>
> >Is there a way to have Postgres re-read the pg_hba.conf file
pg_ctl reload [ -s ] [ -D datadir ]
You might want to check man page on pg_ctl, it's very useful!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Wagoner
Sent: Wednesday, March 16, 2005 8:28 AM
To: PgSQL Admin
Subject: [ADMIN] Re-initialize pg_hba.conf
David Wagoner wrote:
Is there a way to have Postgres re-read the pg_hba.conf file while the
database is up and running (i.e., no restarting)? Perhaps using
SIGHUP?
I think you're right with the SIGHUP. In my init script from Gentoo
there is option to reload (which I think is the same):
su - $P
Is there a way to have Postgres re-read the pg_hba.conf file while the
database is up and running (i.e., no restarting)? Perhaps using
SIGHUP?
I added a user entry to the pg_hba.conf file and cannot bounce the database.
thanks,
david
---(end of broadcast)---
I'm an Oracle DBA first, but I've become very comfortable with
PostGreSql as well. The two have a lot in common and a lot of
differences. MySql in contrast is more used by those here who are very
comfortable with Access. Those two have a lot in common. As for GUI's
their great, until 2AM when a
On Wed, 2005-03-16 at 07:46, Marcin Giedz wrote:
> Dnia wtorek, 15 marca 2005 18:00, Scott Marlowe napisaÅ:
>
> OK now I know I mys query lasts so long:
>
> SELECT DISTINCT t1.Id, t1.IdTypNazwa, t1.IdFirma, t1.Nazwa, t1.NazwaAscii,
> t1.MskNazwa, t3.Id, t3.numer, t3.MskNumer, t4.Id, t4.numer, t4.
Dnia wtorek, 15 marca 2005 18:00, Scott Marlowe napisaÅ:
OK now I know I mys query lasts so long:
SELECT DISTINCT t1.Id, t1.IdTypNazwa, t1.IdFirma, t1.Nazwa, t1.NazwaAscii,
t1.MskNazwa, t3.Id, t3.numer, t3.MskNumer, t4.Id, t4.numer, t4.MskNumer,
t5.Id, t5.numer, t5.MskNumer, t6.Id, t6.numer, t6.M
I suppose I should have apologized if that was off topic entirely, but
seeing as how there are many Admins in this group with 7.x or older
questions being sent, I thought some insight into 8.0+ would be useful for
such a short read to those who were interested enough to follow the link.
As for me,
17 matches
Mail list logo
