> Was wondering if there are ways to completely script a new postgresql installation.
> I need to be able to create the db, users, and db elements from one command so that
> I can included it in a setup routine.
That's rather easy.
A shell script can do roughly the following:
- initdb somewher
> Hey list, I'm just wondering if anyone can point me in the direction of a mirror
> that doesn't suck.
At least in the US, I think I should be pretty decent
(ftp3.us.postgresql.org). I've rate limited down to 6M/s but that should
be enough for anyone. I rsync every 4 hours. If anyone can't
>
> > I'm trying to figure out what version of a source code I have. I know
> > it's a 7.2 release, but how can I find out of it's 7.2, 7.2.3, 7.2.4,
> > etc. FROM THE SOURCE CODE, not from compiling (it doesn't compile, it's
> > testing code).
>
> grep VERSION configure
I did try that,
> I've got one simple(?) question:
> as PostgreSQL doesn't use the name of a database as directory name on
> the hard disk (so does MySQL for example), how do I know, which database
> is directory "18719" or "18750" in the directory ./pgsql/data/base?
Take a look at contrib/oid2name
- Brandon
-
>
> Has anyone out there succeeded in installing Postgres 7.1.3 on an
> x86-based OpenBSD 2.9 install?
Did ya try the ports tree? 7.1.3 is in it if you are tracking
2.9-current. Else, let me know and I can make the the tarball available
for 2.9-release.
- Brandon
I'm looking to make a DB server for a project I'm working on (using pgsql)
and am wondering if people have suggestions?
Thoughts:
- Hardware: dual / quad Intel class
- OS: Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
can do multi proc support
- Disk: SCSI Raid 1+0
- Ram
> I have a cron job which vacuums etc all of my databases but it does not
> work with 7.1.2 because of the change in structure of .../data/base.
>
> It currently says:
>
> for q in /usr/local/pgsql/data/base/*; do
> blaa
> blaa
> done
>
> How does one get an equivalent list of all databases from 7
The web site lists a lot of the limitations for postgresql, but not the
max number of tables that are allowed in a given db. Anyone care to come
up with a number?
- Brandon
b. palmer, [EMAIL PROTECTED]p
