On 15/07/2008 19:31, Bob Pawley wrote:
Is there a GUI for pg_dump???
Yep - it's called PgAdmin!! :-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Reci
ource or use a Windows Installer package - follow the
"binaries" link from the main website.
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cath
tions.
Do read the documentation thoroughly. It's excellent - comprehensive,
well written and well organised.
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cath
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sent via pgsql-general mailing l
.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
database from your C++ app? AFAIK
(not having done it myself) the usual ways to access PG from C/C++ are
via libpq or ODBC.
BTW, *please* don't send email to the list which references remote images.
Ray.
--
Raymond O'Donnell
On 04/07/2008 15:36, Raymond O'Donnell wrote:
Having said that, what you need to do is use the -U option to specify
the Postgres user to use for the connection; if you don't, Postgres will
try to authenticate you as the Windows account under which you're logged
in. Look it
;t, Postgres will
try to authenticate you as the Windows account under which you're logged
in. Look it up in the docs.
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECT
ommand to the server, so you need to run it from the Windows command-line.
Ray.
----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
G
On 26/06/2008 17:43, Ludwig Kniprath wrote:
As far as I know pgadmin uses gtk,
Correct me if I'm wrong, but I don't think PgAdmin uses gtk on Windows.
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cat
it to the correct host with the -h
option.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/rec
On 12/06/2008 19:38, Terry Yapt wrote:
Answering to myself:
Version of PostgreSQL Database:
SELECT VERSION();
Heh - beat me to it. :-) Glad you're sorted.
Ray.
--
Raymond O'Donnell, Director of Music, Galway
uninstall the other version first? I seem to recall that using
the Windows Installer package you can only have one version installed at
a time.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
many
variables as you like.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.or
choice.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/rec
ot;?
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sent via pgsql-general mailing list
tml.
HTH,
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sen
is is what's causing
the error.
HTH,
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http
box at which you fire off your SQL and get back
the results.
HTH,
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals:
ation process.
Ray.
----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
EXECUTE?
Ray.
------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
--
--
Sent via pgsql-general mailing list (pgsql-genera
t and the time in
"Total runtime" if effectively the time taken to apply the update.
Beyond that, I'm guessing.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral,
re.
As I understand it, "cost" signifies the planner's estimate of how long
the query will take, in terms of disk page fetches. The "actual time" is
in milliseconds.
Ray.
-------
Raymond O'Donnell, Director of
ng-explain.html
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
On 31/03/2008 20:38, mark wrote:
I dont manually do vaccum..
It might be worth doing one and seeing if it makes a difference.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
is also slowing down the inserts that
happen.
Are you VACUUMing the table regularly?
Also, can you show us the EXPLAIN ANALYZE output from the query?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
1. b
2. b
3. b
4. c
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgsql-general mailing list (pgsql-ge
?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
save typing the column nameshowever, by the
time I've finished reformatting it, typing them directly would have been
just as fast. :-)
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral,
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
this
for you in one go.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgsql-general mailing list (pgsql-general@post
sing after the INSERT statement, which may
or may not cause problems.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
-
d also use CURRENT_TIMESTAMP - look at the following:
http://www.postgresql.org/docs/8.3/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
e command you
need run.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
-
Sent via pgsql-general mailing list (pgsql-general@post
think it's been that way for
source-code installations too, in recent versions at least, though I'm
open to correction on this.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
On 09/03/2008 22:33, Reid Thompson wrote:
On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
On 09/03/2008 15:34, Reid Thompson wrote:
you'll also probably have to add the parameter -h 127.0.0.1
psql defaults to connecting to the local machine unless you tell it
otherwis
her.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
is usually set when that
client connects (with a "SET client_encoding" statement); and Postgres
translates happily between the two.
Forgive me if I'm wrongjust reading between the lines. :-)
Ray.
-----------
Raymond O
On 08/03/2008 19:46, akshay bhat wrote:
now can someone please tell me where to execute above command
should i use dos (i mean command prompt )
Yes, that's it - run it at the command prompt.
Ray.
---
Raymond O'Donnell, D
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2:
hives? - http://archives.postgresql.org/
HTH,
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
On 19/02/2008 15:43, HHB wrote:
How to use a sequence in such text files?
You're looking for the nextval() function - look it up in the docs.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
On 18/02/2008 17:46, Raymond O'Donnell wrote:
Well, that depends on your usage, so only you can answer that. According
to the docs, "serial" creates an integer column, which will give you
2147483647 values - how quickly will you use that lot up? If you think
you will run ou
ial.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 9: In
There's at least one website out there that offers DLLs for download,
but I have no idea whether this is legal or not. Can anyone comment?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
.html
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
so, then the pooled connections remain open, which - as someone else has
explained - causes sessions to be maintained.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
select "Senha"
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 1: if postin
same as
select "Senha" .
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
-
ts of examples.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ff
there too.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 4: H
ely under the fingers. :-)
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
executing
COMMENT ON TABLE yourtablename IS 'comment here';
There's no comment created by default.
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathe
- pg_dump exports the SQL to recreate
the sequence, and a setval() to reset it to where it was.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
eate a new data directory without having to uninstall first.
Have a look at the docs, here:
http://www.postgresql.org/docs/8.2/static/creating-cluster.html
It's pretty much the same on Windows as on *nix.
HTH,
Ray.
-------
Raymond O'
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desi
On 21/01/2008 18:57, Bob Pawley wrote:
Is there any method of incorporating the graphics into PostgreSQL so
that they become part of the database on pg_dump
Surely - use type bytea.
Ray.
---
Raymond O'Donnell, Director of
gives sample
solutions to all sorts of problems in SQL suitable for PostgreSQL,
MySQL, DB2, SQL Server and Oracle.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway
On 16/01/2008 23:10, Ted Byers wrote:
Does it count if I lived there for a year many many
years ago? ;-)
...or if I visited for a day or two in 1986? ;-)
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ir
ver
half-way down.
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 1: if posting/reading
ata directory.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain analyze is your friend
same order
r1,r2,r3,r4,r5? Does this apply to big tables also?
If you use the text dump format, you can see the order in which the rows
are restored.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
SQL
via a query window.
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)--
able?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 5: don't for
d commercial rates for all the
free help they've given on this lists, I wonder how much they'd have
made by now? :-)
Ray.
-------
Raymond O'Donnell, Director of Musi
op-post, as it makes for confusing reading.
* Don't start a new thread by replying to an old one, because [insert
suitable technical explanation here].
Failure to observe the above may result in your question going unanswered.
// <<<<<
Ray.
----
recall, that's exactly what template0 is for - it's to let you
restore template1 to pristine condition if you fill it with crud (which
I've managed to do once or twice).
Ray.
-------
Raymond O'Donnell, Director of Mus
d'etre/.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP
the standalone program vacuumdb and redirect its output, thus:
vacuumdb -U postgres your_database >out.txt 2>&1
HTH
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathe
t one
whopping database load-balanced across the servers?
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
.]. If you compiled
from source (make, then make install, etc), I'd simply remove the
installation and source directories by hand.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
dd a
line to it requiring a password for your new user and the host from
which it is connecting.
http://www.postgresql.org/docs/8.2/interactive/client-authentication.html
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, G
you have to store all the users created thus far so as to tell
who's new, so it gets a little messy.
Just thinking out loud
Ray.
-------
Raymond O'Donnell, Director of Music, Galway
e you some pointers.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(e
On 19/11/2007 22:05, Raymond O'Donnell wrote:
On 19/11/2007 21:44, Thomas Kellerer wrote:
But I have no clue how you would enable the module after the
installation has finished.
I think you have to run an SQL script to enable the module.
Sorry, that wasn't very helpful. :-) I s
On 19/11/2007 21:44, Thomas Kellerer wrote:
But I have no clue how you would enable the module after the
installation has finished.
I think you have to run an SQL script to enable the module.
Ray.
---
Raymond O'Donnell, Dir
On 16/11/2007 10:02, Sam Mason wrote:
SELECT COUNT(*) FROM (
DELETE FROM foo RETURNING 1) x;
I haven't played with this yet, but AFAICS this will simply return the
integer value "1".
Ray.
-------
Raymond O'
function takes the place of a table in the SELECT statement.
HTH
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
generated SQL into my email - hence the pedantically complete statement. :-)
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[
.html
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 6: explain an
On 01/11/2007 20:19, Dawid Kuroczko wrote:
> Any other idea how to efficiently solve such a problem?
How about creating a temporary table within your function and using that
instead?
Ray.
---
Raymond O'Donnell, Director
e doesn't if the dump is going
to create the database)but it can trap the unwary.
See the docs at
http://www.postgresql.org/docs/8.2/static/reference-client.html
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cat
m
time to time on this list, so it'd be worth your while having a trawl
through the archives.
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
On 23/10/2007 01:06, Andrej Ricnik-Bay wrote:
Now if one could put names to those faces ... :}
+1 :-)
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROT
On 18/10/2007 22:26, Laurent ROCHE wrote:
No idea what GUC is, though !
Grand Unified Contraption? ;-)
Ray (who's just been reading Jules Verne).
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL
eful examples.
HTH,
Ray.
-----------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
tf8
I had thought that the -d option was to specify the database, but of
course not.
Thanks all - I'm sadder and wiser!
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Irel
. Not a problem, but I
was curious.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of
p; summer time?
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)--
On 28/08/2007 15:48, Jeff Amiel wrote:
Alien or supernatural intervention: 18-1
Obscure postgresql bug nobody else has ever seen: 25-1
That's the sort of confidence in the DBMS we all like to see! :-)
Ray.
---
Raymond O
On 18/08/2007 19:30, Muhyiddin A.M Hayat wrote:
somebody help me please
You'll need to post a lot more information before anyone can help.
Is there anything in the server log? - or the Windows event log?
Ray.
---
Raymond O
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
.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
TIP 2:
.just curious. - Thanks for
explaining.
Ray.
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of
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
ump.html
HTH,
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
T
it.
Ray.
-------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---
---(end of broadcast)---
801 - 900 of 1053 matches
Mail list logo