Sorry if this is a FAQ, but I couldn't find it.
If my (RH 7.1) system crashes PostgreSQL does not restart automatically
because the shared memory segment identifier and the .pid file remains,
as a manual start explains:
% pg_ctl start
pg_ctl: Another postmaster may be running. Trying to s
Hi guys,
I've seen a lot of traffic around the developer lists about performing
live backups by duplicating the WAL control files, but no examples of this
actually working. I don't need instant fallback or any of the funky stuff
listed in the TODO file, but I need to build a database which is no
Hello.
We are running PostgreSQL 7.1.3 on Debian GNU/Linux.
We maintain for our intranet something like an addressbook :
=# \d adresses
Table "adresses"
Attribute | Type | Modifier
--+-
Thanks Peter, that got me a little further.
Anyone out there gotten pgAcess working on Mac OS X? I haven't been
able to make my way through a configure using the new 8.4 Tk
snapshots that are up on the sourceforge site. I'm getting the
following error:
configure: error: file 'tkConfig.sh' is
Hi,
Sorry if this has been covered before, but I haven't been able to find
any information about it.
I'm running PostgreSQL 7.0.3 with the following command:
postmaster -i -D/var/pgsql/data -N 32 -B 64
Normally, 32 connections is heaps for what I need. However, I often get
connections tha
On Tue, 16 Oct 2001 18:42:19 +0100, Allan Engelhardt <[EMAIL PROTECTED]> wrote:
> OK, I'm probably doing something very stupid, but can somebody explain how I'm
>supposed to restore a custom archive dump?
>
> $ createdb foo
> CREATE DATABASE
> $ psql foo
> foo=# create table users (id serial);
>
Hi all,
I'm not a Linux Guru and I'm trying to install PG 7.1.3 on Suse 7.2.
Unfortunately SuSe has not prepared a packet yet and the last Suse version
is 7.0.3.
In any case, I have some questions to do a good job.
1) Is it better to install from source or from SRPM ?
2) Where have I to put the
Oh, no! Please don't tell me I also can't use BLOB in PostgreSQL.
Surely there is a way to backup and restore the *whole* database?
I've tried creating the database manually and then
$ droplang plpgsql foo
before the restore, but that didn't work either. The language is, of
course, c
Allan Engelhardt <[EMAIL PROTECTED]> writes:
> If my (RH 7.1) system crashes PostgreSQL does not restart automatically
> because the shared memory segment identifier and the .pid file remains,
That's kinda hard to believe; how would a shared memory segment survive
a system crash?
> % pg_ctl
>1) Is it better to install from source or from SRPM ?
Compile manually. reason: up to date.
>2) Where have I to put the binaries and data ?
>I know the default are: /usr/local/pgsql/bin/ and /usr/local/pgsql/data/
>but SUSE use /usr/bin/ and /var/lib/pgsql/data.
just leave the defaults of
On Wed, 17 Oct 2001, Nicolas KOWALSKI wrote:
> =# \d adresses
> Table "adresses"
> Attribute | Type | Modifier
>
> --++
> id
Tom Lane wrote:
> Allan Engelhardt <[EMAIL PROTECTED]> writes:
>
>>If my (RH 7.1) system crashes PostgreSQL does not restart automatically
>>because the shared memory segment identifier and the .pid file remains,
>>
>
> That's kinda hard to believe; how would a shared memory segment survive
>
Giles Constant writes:
> I've seen a lot of traffic around the developer lists about performing
> live backups by duplicating the WAL control files, but no examples of this
> actually working.
That's because it doesn't work. There are no plans to make WAL into a
replication facility, for reason
On Sun, 14 Oct 2001, Marc Spitzer wrote:
> In article <[EMAIL PROTECTED]>, Brian McCane wrote:
> >
> > Being the perpetually lazy person that I am, I have written a PERL script
> > that takes care of indexes on a live system. You tell the script the
> > database and table to re-index. It then f
14 matches
Mail list logo
