;>
>> I feel neither the installation or the small postgres databases I would have
>> created use 121GB.
>>
>> Any reason why it shows 121GB
>
> Could you share with us \l+ command in psql session ?
Also, see what Windows reports as the space taken up by the install
SV file? - if so, delete it and try again.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
onsistency if I forget update/export/import on 1 or more
> table. It is terrible.
You could create a view specifically for export, which would gather
together data from all the tables.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing
m where ~
http://www.postgresql.org/docs/9.4/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.
fline all the time.
> Is there another possibility to migrate a database with 200 GB ?
Those version numbers aren't correct... current PG major versions run
from 9.0 to 9.4. I don't think there was ever any version less than 6
(though I could be wrong).
Ray.
--
Raymond O'Donn
integrity?
I'd create the tables in the new schema without the FK constraints, copy
the data, then add the constraints afterwards.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
On 23/04/2015 19:08, Raymond O'Donnell wrote:
> On 23/04/2015 18:09, Cory Tucker wrote:
>> I have the need to move a specific set of data from one schema to
>> another. These schemas are on the same database instance and have all
>> of the same relations defined. The
matically if they are not in use by other
> services or programs”
Hi there,
Sounds like you're on Windows - you can get more information from
PostgreSQL's own logs, which by default on Windows are in a directory
called pg_log under the data directory.
Ray.
--
Raymond O'Donn
lays with Windows, I've no idea I'd guess that changing
the drive letter might well cause Bad Things to happen.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
able where number * 3 between start_value3 and end_value3;
If they're all the same table, just use OR:
... where (number * 3 between start_value1 and end_value1) or (number *
3 between) etc.
Or am I missing something?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.
ion_size = 10MB
The comments in postgresql.conf indicate that log_destintion and
logging_collector, at least, need to be set as above to generate log files.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.o
On 18/06/2015 13:13, Maila Fatticcioni wrote:
> On 06/18/2015 11:48 AM, Raymond O'Donnell wrote:
>> On 18/06/2015 10:34, Maila Fatticcioni wrote:
>>> Hello. I have a postgres cluster made by two nodes with OS Ubuntu
>>> 14.04. About two weeks ago I did a minor updat
> RETURN;
> END;
> $$ language 'plpgsql';
>
> mydb=> select myfunc('foo','bar');
You need to do:
select * from myfunc('foo','bar');
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
name='US/Eastern'),'-MM-DD
> HH24'||':'||'MI'||':'||'SS')::timestamptz;
>
> it's not displaying timezone..any help..?
>
Because TIMESTAMPTZ - TIMESTAMPTZ = INTERVAL, not TIMESTAMPTZ.
Also, why on earth are you do
g? And if not in the official documentation is it in the wiki?
session_user, current_timestamp and current_user are all functions, not
magic constants:
http://www.postgresql.org/docs/9.4/static/functions-datetime.html
http://www.postgresql.org/docs/9.4/static/functions-info.html
I hop
>
> it's not displaying timezone..any help..?
Hi there,
This question was answered a few days ago, but perhaps you didn't see
it. The reason you don't get timezone information is that subtracting
two timestamps results in an interval value. See table 9-27 on this page:
h
"postgres" (or whatever
user you used to connect):
alter role postgres with password 'whatever';
Don't forget to edit pg_hba.conf once again and set "trust" back to
"md5' (and re-start the service).
Finally, note that the "postgres" user is the
e are tons of documentation and examples
out there - Google is your friend. Qt's own documentation is very good.
For plain C, read PostgreSQL's own docs:
http://www.postgresql.org/docs/9.4/static/libpq.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via
coming from
192.168.02.64, whereas you specified 127.0.0.1 in pg_hba.conf.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ember having them!!!)
>> Oh, so you name your tables 'fish' and 'crow' instead of 'school' and
>> 'murder' ? Such wasted opportunities :p
>>
> ???
A school of fish and a murder of crows... wonderfully evocative
collective nouns.
Ray
On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
> No worries.
>
> I found a way.
>
Would you share it, for the archives?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
ection. There's
probably something simple that I'm just not seeing
If anyone's interested, these numbers represent channels and pistons on
the combination system of a largish pipe organ... it's for a hobby project.
Many thanks in advance!
Ray.
--
Raymond O'
On 05/10/2015 19:53, Adrian Klaver wrote:
> On 10/05/2015 11:39 AM, Raymond O'Donnell wrote:
>> Hello all,
>>
>> I have an SQL problem which ought to be simple, but I can't get my head
>> around it.
>>
>> I have pairs of integers - let's call
ften a geometrical solution to an algebraic problem.
Thanks!
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05/10/2015 20:08, Adrian Klaver wrote:
> On 10/05/2015 12:00 PM, Raymond O'Donnell wrote:
>> On 05/10/2015 19:53, Adrian Klaver wrote:
>>> On 10/05/2015 11:39 AM, Raymond O'Donnell wrote:
>>>> Hello all,
>>>>
>>>> I have
mals (
id serial,
taxonid integer, -- use the lookup table
parentid integer, -- use the lookup table
constraint mammals_taxon_fk foreign key (taxonid) references
taxon(taxonid)
);
If parentid also references taxon.taxonid, add a similar constraint for
it too,
Ray.
--
Raymond O
#x27;t visible, you can make it visible under
the "View" menu.
As a bonus, you can select a block of SQL and only the selected code
will get executed.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
1]
http://www.postgresql.org/docs/9.4/static/datatype-numeric.html#DATATYPE-SERIAL
[2] http://www.pgadmin.org/support/list.php
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 20/07/16 16:57, John DeSoi wrote:
On Jul 18, 2016, at 11:47 PM, John R Pierce
wrote:
Drupal even tried to offer a database API so plugin developers
wouldn't touch SQL directly, but too many ignored it.
I have been using Drupal with PostgreSQL for more than 10 years
without too many probl
On 04/09/16 19:33, Lukas Lehner wrote:
Hi
when I use a search engine for the term "Postgres Certification"
this page shows up
https://www.postgresql.org/about/news/333/
please remove that, very much outdated. The referenced link doesn't
exist anymore (404 No such domain)
In all fairness, th
On 13/09/16 19:03, Steve Crawford wrote:
I'm trying to install 9.6 RC1 on Ubuntu 16.04 Xenial on my laptop and it
seems broken.
Installation of 9.6 RC1 on Centos was straightforward by comparison -
just add the 9.6 yum package and install. Unfortunately Ubuntu seems
second-class by comparison.
On 03/10/16 14:39, dudedoe01 wrote:
What is the most feasible way to emulate the below MySQL function into
postgreSQL. Since the isnull() function is no longer supported in 9.6
version. I have tried every trick in the hat to get the desired results.
Still 'RPG INV' doesn't show only the other two
On 17/10/16 16:40, said assemlal wrote:
Hello,
I am looking for a way to test generically input arguments to raise an
exception if one is either null or empty.
I was thinking to create a function who takes an array to check them but
not sure if it's really good.
It's not clear what you want t
On 08/11/16 18:24, Joshua D. Drake wrote:
Hello,
Drupal + Ubercart should service your needs.
+1 to what the others said about Drupal + Ubercart: easy to set up, but
very customisable too if you need to. There are a number of
freely-available themes which are aimed at online shops and work v
On 10/11/16 10:34, Juliano wrote:
Hi,
I'm trying to import some data from a MS SQL Server 2014 sequential
database to Postgresql using dbi-link.
Have you tried the foreign data wrapper for MS SQL Server? It's here:
https://wiki.postgresql.org/wiki/Foreign_data_wrappers#Specific_SQL_Database
I seem to remember that it was actually deprecated at some point - this
is going back quite a few years. This was later reversed, though I don't
know why.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
://wiki.postgresql.org/wiki/Apt
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is there any other way to access, i am getting null for
product_list[i][0];
By default, PostgreSQL uses 1-based arrays (i.e. no [0] slot), so maybe
that's your problem.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgs
On 09/12/16 10:42, Raymond O'Donnell wrote:
On 09/12/16 06:35, VENKTESH GUTTEDAR wrote:
Hello,
Please help me in accessing multi-dimentional array in postgresql
PL/PGSQL.
for i in array_lower(product_list, 1) .. array_upper(product_list, 1)
LOOP
product_list[i][0];
On 09/12/16 15:30, Tom Lane wrote:
As of 9.6 you could use the shorthand
array_value = Eg[i][:]
regards, tom lane
I hadn't spotted that - very handy - will go and read up on it. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
-
rray($ipsrc));
if(!$query) { print error...}
Are you sure it's failing? Try this:
if ($query === false) {
}
PHP has funny ideas about what's true and false.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@pos
"select count(*)
from ...", or something else?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
DROP INDEX "Raum_RaumID_idx";
CREATE INDEX "Raum_RaumID_idx"
ON "Raum"
USING btree
("RaumID");
But psql tells me "Raum" is not existent:
egon@xfEinzel ~ $ psql Hausrat
psql (9.3.15)
Type "help" for help.
Hausrat=# SELECT * FROM Raum;
this, but did you
run ANALYZE on the table after creating it? - Depending on how you
created the table, the statistics needed by the planner may or may not
have been up to date.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgs
type out your column
names - I'm only guessing without seeing the DDL, but it sounds as if a
column called macro_lookup_id exists in more than one table.
You'll need to do something like this:
select
sample.macro_lookup_id as col_name_1,
macroscopic.macro_lookup_id as col_name_2
ist - thanks!]
You'd better show us your table structures - we're only guessing
otherwise. However, I think typing efficiency isn't important, but
rather what your application needs to do with the data - you only type
the query once. :-)
--
Raymond O'Donnell :: Galway :: Ireland
ro_lookup_id) MATCH SIMPLE
> ON UPDATE CASCADE ON DELETE RESTRICT.
>
> In 9.3 is there an alter constraint option or do I have to drop the
> constraint and add the new one?
I just had a quick look at the docs for 9.3:
http://www.postgresql.org/docs/9.3/static/sql-altertable
t; pde.deleted = ''''N'''' and
> p.deleted = ''''N'''' and
> pt.deleted = ''''N'''' and
> de.local_date between ''''$2'''' and ''''$3'''' and
I missed whatever passed upthread, but at a guess I'd say all the
quoting is causing problems here. Why not use the quote_ident() and
quote_literal() functions? By the same token, I don't think you need to
put quotation marks around the parameters.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 25/01/2016 10:16, Brian Cardarella wrote:
> Is it possible, and if so how, to dump and then load a database to/from
> a file from within a psql connection?
You can use the COPY command to do a table at a time, but you'll get
just the data - you won't get permissions etc.
R
ly unique in their respective tables,
having additional serial and domain_id columns seems like overkill. Why
not ditch them and use the domain name and username as the primary keys?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with "d.id" (partly my
mistake, I missed that the column is called "id" and not "domain_id" in
the domains table).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/02/2016 13:57, arnaud gaboury wrote:
> On Wed, Feb 3, 2016 at 2:19 PM, Raymond O'Donnell wrote:
>> On 03/02/2016 13:11, arnaud gaboury wrote:
>>
>>> Hum hum...
>>> --
>>> SELECT u.use
t null,
password text not null,
domain_name text not null,
created timestamp with time zone not null default now(),
constraint users_pk primary key (username, domain_name),
constraint users_domains_fk foreign key (domain_name)
references domains(domain_name)
);
And then your query would look somethi
://www.postgresql.org/download/solaris/
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s in the row_to_json function and
> include only the fields that are non-null?
You could use a CTE to filter out the nulls (not tested - I haven't used
JSON in PG (yet!)):
with no_nulls as (
select ... from my_table
where whatever is not null
)
select row_to_json() from no_nulls;
readable when you use long table / fiel names.
I reckon this is just a matter of style... I use underscores to make
long names readable...
create table my_table_with_a_really_long_name;
and it works fine.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via p
postgresql.org/docs/9./static/release-9-6.html
^^^
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
o upstream bugs in
wxWidgets, over which the pgAdmin team has no control (hence pgAdmin 4).
Having said all that, I've rarely had any trouble with pgAdmin 3 on
Windows 7 and XP, Ubuntu and Debian; just a very occasional crash (maybe
one every six months).
Ray.
--
Raymond O'Donnell
On 25/05/16 20:57, Jeff Janes wrote:
On Wed, May 25, 2016 at 10:31 AM, Sameer Kumar wrote:
On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote:
I've recently wanted to run a different archive_command during
database shutdown than during normal operations. In particular, if
the normal archive
all the time and am very happy with it.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(e
pful.
Thanks,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 4: Have you s
On 30/05/2007 00:11, Guy Rouillier wrote:
I'm not one of the developers, but I found the following information
here http://www.postgresql.org/developer/roadmap:
That's great - thanks.
Ray.
-------
Raymond O'Donnell, Di
es; I'd like to see something
similar in PHP.
Apologies if this is off-topic for this list, but I'm curious as to why
others reckon that PHP sucks.
Ray.
-------
Raymond O'Donnell, D
#x27;t pg_pconnect supposed to recycle a pooled connection?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
-
braries or DLLs (unless you create them yourself, of
course). That does mean that a Win32 GUI app will be around 300k or so
minimum.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
ion minimum(a1 integer, a2 integer) returns integer as
$$
begin
if a1 < a2 then
return a1;
else
return a2;
end if;
end;
$$
language plpgsql;
- and then you can call it in one line:
select minimum(5, 4);
Ray.
---
R
this list in the last
eighteen months or so about storing binary files in a database vs
storing them in the filesystem - you may find it useful to have a look
through the archives.
Ray.
---
Raymond O'Donnell, Director of Music, G
are for making
front-end GUIs (for the most part), whereas PostgreSQL is a database.
Have you looked at pgAdmin?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
58 days 21:10:36.748
(1 row)
Of course, you'll need to decide how to handle the part of a day left over.
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
instead of using jdbc/odbc.
Also, if the files you're importing were created by pg_dump, they'll
contain various "backslash" commands that are psql-specific, so you
*have* to re-import them via psql.
HTH,
Ray.
-----
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain analyze is your friend
I'll pass them on.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
On 04/07/2007 17:34, Cesar Alvarez wrote:
is there a way to store pictures or executables in postgres??
http://www.postgresql.org/docs/8.2/static/datatype-binary.html
---
Raymond O'Donnell, Director of Music, Galway Cath
separate "Catalogs" node in the treeview on the left.
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, I
elp.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 09/07/2007 18:33, Raymond O'Donnell wrote:
I you have a look through the (reasonably recent) archives of this list,
Whoops - that should have been "If you" - sorry for any confusion.
Ray.
-------
Raymond O'
ption? - this
forces a password prompt.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of
file?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
.
Usage:
psql [OPTIONS]... [DBNAME [USERNAME]]
Output format options:
-P VAR[=ARG]set printing option VAR to ARG (see \pset command)
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EM
On 23/07/2007 14:51, Perry Smith wrote:
Ah... I knew that. I always assume it does, then it doesn't work, then
I look at the man page. Sorry.
Been there, still wearing the t-shirt! :-)
Ray.
---
Raymond O'Donnell, D
got a
snapshot from the pgAdmin site. The current stable version is 1.6, and
1.8 is in beta.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
T
ted in
people's comments.
This machine will be running PostgreSQL and nothing else, and I'll
probably compile Postgres from source.
Ray.
-------
Raymond O'Donnell, Director of Music, Ga
date,
etc...
check (the_date >= '1900-01-01' and the_date <= '2020-12-31')
);
Then you just need to handle in your application the error raised when
someone enters an incorrect date.
HTH,
Ray.
-------
Raymo
oint. :-)
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner wil
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
up database.
Do the backup from a shell script that names the output file with the
current date/time.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
ther words, how do I select those rows in "people" which don't have
a corresponding row in "items_for_people" for *each* row in "items"
which has is_required=true?
Many thanks,
Ray.
-------
Raymond O
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 10/08/2007 19:10, Tom Lane wrote:
Use the "verbose" option.
[/me tries it out]
That'll do nicely - thanks.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
ving count(*) = ..." to
"having count(*) >= ..." to allow for people having other items in
addition to the required ones.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Ca
required items, whatever
else they may have.
Comments and improvements are welcome!
Thanks for the help,
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathe
ler package inside the zip won't work.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---
it.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
ump.html
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
T
On 17/08/2007 13:32, Raymond O'Donnell wrote:
Was the previous installation of Postgres also 8.2? If not - if it was
an earlier version - I'd put the old version back, point it at the data
directory, then use pg_dump to export the data if you want to upgrade at
that point.
I me
.just curious. - Thanks for
explaining.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2:
le people can help.
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 9: In versions below 8.0, the p
1 - 100 of 1053 matches
Mail list logo