read; it may give yuo some comfort.
Ray.
You make me crazy with this behaviour.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
nformation may
be out of date).
Somebody please correct me, if in fact, even the server component
requires python. Seems like bloat otherwise.
No, the server is written in C so it doesn't require Python (unless of
course you're using PL/Python).
Ray.
--
Raymond O'Donnell :: G
t
Hope this helps.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
uum.html
Hope this helps,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 14/11/16 19:34, Chase Freeman wrote:
All thanks for the replies--I'm using MacOS Sierra.
I'm afraid I don't know anything about MacOS, but in general PgAdmin
doesn't include the PostgreSQL utilities such as pg_dump etc; it instead
depends on these being installed separately, and you then
On 12/11/16 00:27, Chase Freeman wrote:
Hello,
Can someone help me understand how to find the solution so I can setup
my Binary path?
Path to the directory containing the PostgreSQL utility programs
(pg_dump, pg_restore etc).
This as you've said above - you need to specify where these utiliti
On 03/10/16 09:19, Christoph Berg wrote:
Re: Raymond O'Donnell 2016-10-03 <37fa58f1-518f-409e-129e-0a1f52569...@iol.ie>
Hi all,
As per $subjectdoes such an animal exist?
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=834129
Aha - thanks.
Ray.
--
Sent via pgadmin-supp
Hi all,
As per $subjectdoes such an animal exist?
Congrats to Dave and the team on getting it out the door - looking
forward to trying it out!
Thanks,
Ray.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgre
On 09/07/16 15:07, Colin Beckingham wrote:
On 09/07/16 09:52, Nico Aliotta wrote:
i'm tryng to access to a db that is on a my server.
The port is 5432 open and accept tcp/ip connections.
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not conne
PostgreSQL
(ii) Platform on which PostgreSQL is running
(iii) Platform on which PgAdmin is running
(iv) Steps to reproduce the problem
(v) Exact error message you get
(vi) Anything in the logs which may be relevant
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent
ored to
> the windows server and now I need to set up access for users on Active
> Directory. I’ve read a few things online, but did not find any good
Hi there,
You'd be better off asking on the pgsql-general mailing list. This one
is dedicated to PgAdmin, the PostgreSQL administration to
On 18/02/2016 20:55, Gene Hansen wrote:
> Please stop sending emails.
>
You're subscribed to a mailing list. Instructions for unsubscribing are
in the footer of every email from the list.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-supp
ws 7 (64-bit) without any problem (so far anyway;
fairly light use).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
; it needs to be run through psql.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
hines
> (8.4.0.9177).
>
> Is there a difference in the back up file if win 7 64 creates it versus
> win xp creating it?
Only guessing here, but could it be a 32/64-bit problem?
You could also try using the text format for the backup, if your
database isn't too big - that's
atory, and the help files that come with PgAdmin
are good too.
(i) Click File -> Add Server.
(ii) Fill in the details of the server - host, port, username, password,
etc.
(iii) Click "OK".
That should be it.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
lly starts it up - but
you can start it manually from the Control Panel -> Services (under
Windows 7 anyway; I don't have Windows 8).
If it doesn't start, there's some other problem... You should post to
the pgsql-general mailing list; this one is for PgAdmin, which is a
Postg
>
>
> ERROR: syntax error at or near "perform"
>
> LINE 1: perform standupdatestatus('12', 'Loaded', 100);
You probably need to do:
perform * from standupdatestatus(...);
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
t just because it's (deliberately?)
>> broken.
Also, as I said already, if there is a problem with the unsubscribe
page, it would be much more helpful to tell the list *exactly* what
error you got - you haven't done that yet.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
On 07/03/2015 13:43, hushthatb...@hushmail.com wrote:
> Nothing happens on that page except for a bunch of error messages and
> unrelated garbage.
>
> Is this like a joke? Why can't I unsubscribe from this mailing list?!
>
> On 2015-03-07 at 2:41 PM, "Raymond O
On 07/03/2015 13:31, hushthatb...@hushmail.com wrote:
> I wanna unsubscribe immediately. How do I do it?!
>
Just read the footer of every email from the list:
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
:-)
--
Raymond O'
On 07/03/2015 00:15, Jan-Peter Seifert wrote:
> Am 06.03.2015 um 19:33 schrieb Raymond O'Donnell:
>
>> pgAdmin just uses pg_dump [1] to do the actual backup, so it would be
>> interesting to run pg_dump directly at the command line to see if the
>> same behaviour m
self.
Ray.
[1] http://www.postgresql.org/docs/9.3/static/app-pgdump.html
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
options...]
If it's one of the others, you need to use pg_restore:
http://www.postgresql.org/docs/9.4/static/app-pgrestore.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To
" --verbose -F p
> --file "D:\EMS1.backup" "GROVEL" pause
This question isn't relevant to pgAdmin; you'd do better to post to
pgsql-general instead.
Having said that, there's no --password option to pg_dump. You need to
use a .pgpass file instead:
to get this "real time" rather than the "pointless time"?
Do this -
explain analyze (your query)
- to get the execution time.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make
in 1.20.0 (revision REL-1_20_0), on Windows 7.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
s or is it just me?
I'm using the release version of 1.20.0 on Windows 7, and it's perfectly
stable; though I'm not using an SSH tunnel.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 31/12/2014 12:46, Raymond O'Donnell wrote:
> On 31/12/2014 10:42, Gopalan, Narayanasamy wrote:
>> Hi,
>>
>>
>>
>> We are using PostgreSQL, we need to back up the database and restore
>> onto a different server. We re unable to connect to it
rd';
I hope this helps.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
ck on the "Tables" node, and then you should
get a "New table" context menu item.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
.. but I'd be happy to test if such a feature
were ever implemented.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
turned exit code 1.
>
> What this tells me is that the NEW version of pgAdmin is using the OLD
> version’s pgDump.
>
> However, I can’t locate where this is defined. I checked the registry;
> Base Directory (for both) points to the correct folder
>
> Would appreciate any poin
ut of curiosity, what are you using in place of wxWidgets?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
t;)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www
/www.pgadmin.org/docs/1.18/query.html
- where you'll see that ctrl-space is now used for autocompletion. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 17/06/2014 11:17, Oliver wrote:
> Ah thanks Ray, I'm sorry.
>
> Cheers...
Hi Oliver,
It's not a problem. :-) But you'll get advice from a much wider range of
people on that list, at least regarding general PG questions such as yours.
All the best,
Ray.
--
Ray
g as it will be for production).
> Could someone recommend me a strategy for backups, scripts and so on?
Hi there,
You should post to the pgsql-general mailing list; this one is
specifically for PgAdmin, the administration GUI for PostgreSQL.
Ray.
--
Raymond O'Donnell :: Galway
behavior, or do
> we have to revert to an older version of PostgreSQL?
This case-folding behaviour has been standard in PostgreSQL for a very
long time; certainly since I started using PostgreSQL (about version 7.3
I think).
Anyway, short version - there aren't any double-quotes in the tabl
initialised.
Where would similar variables be set? - that'd be a good place to start
looking.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
tually share his experience.
Hi there,
This list is for pgAdmin, the GUI administrative tool for PostgreSQL.
For questions such as yours, which relate to Postgres itself, you'd be
better off posting to the pgsql-general list.
Regards,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@
s whose names never appear
on this list volunteer a huge amount of their own time to make pgAdmin
the great tool that it is, with little or no thanks for it. PgAdmin is
the result of a community effort, not a corporate enterprise.
Ray.
--
Raymond O'Donnell :: Galway :: Irela
D" on the applicable rule to "trust". Reload the server to
make the new setting take effect, and then you'll be able to log in
without a password. Reset your password; and then change the
authentication method back to "md5" or whatever it was before (don't
forget t
integer, 'Dezembro'::text, 'Dez'::text)) as meses(mes,
> nome, sigla)
>where mes = iMes;
>
> if sTipoRetorno = 'nome' then
> return sNomeMes;
> else
> return sSiglaMes;
> end if;
> end;
> $_$;
>
>
> ALTER FUNCTION public.fc_mesextenso(integer, character varying) OWNER TO
> sigmasol;
>
What is your question?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Go to File -> Options, then under
Browser -> Binary paths enter the path to these programs for "PG bin path".
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscri
type. The data types available in pl/pgsql
are the same as for plain SQL:
http://www.postgresql.org/docs/9.2/static/datatype.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
; you can instead use
an environment variable[1] or a .pgpass file[2].
HTH,
Ray.
[1] http://www.postgresql.org/docs/9.2/static/libpq-envars.html
[2] http://www.postgresql.org/docs/9.2/static/libpq-pgpass.html
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-
ns exactly what it says - the username/password combination you
supplied was invalid.
Can you connect as that user with psql? If so, the password is the same.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.
sword
> localhost:5432:*:django_dev:Password
Is that second line faulty? Shouldn't the first field contain either a
hostname, an IP address or "*", but not simply nothing?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list
eries to filter the records by any criteria except complex queries.
>
> But as I see the Data Grid is readonly here...
[Copying back to the list]
Ah, yes, I misunderstood you. No, you can't do that in pgAdmin.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent
On 14/11/2012 15:15, durumd...@gmail.com wrote:
> Hi!
>
> I search for "live" query option in pgadmin, where I can update the requested
> data in the editor.
>
> Or pgadmin doesn't supports this function yet?
Sure - just press F5, or hit the "Run"
t install 9.2, the latest?
If you really must install 9.0, you should install 9.0.10, which has 8
versions' worth of bug and security fixes.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make
On 13/10/2012 18:44, Raymond O'Donnell wrote:
> On 13/10/2012 18:25, Vince Miller wrote:
>> Hi,
>>
>> I'm trying to connect with pgadmin3 from my Windows box across my lan
>> to my working database on my new working Ubuntu 12.04/postgresql 9.1
>> datab
.dattablespace
> AS spcoid,spcname,datallowconn,datconfig...'
>
> then another that says
>
> 'Column not found in pgSET: rolconfig'
I vaguely remember seeing this on one of the mailing lists before, and
it turned out to be some sort of version mis-match
e to remind yourself how the data is represented in each
> view.
+1 to the above - if it's possible, I'd also like to see consistency
across all of PgAdmin on the display of nulls in particular.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support
g list for such feature requests?
No. :-)
Try pgsql-general instead; this list is for PgAdmin.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
um database which is based on PostgreSQL 8.2 but it
> appears any 8.2 database will have this problem.
AFAIK 8.2 isn't supported any more, either by the PostgreSQL community
or by PgAdmin.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing lis
: 5432
>
> Please, could you tell me where I have made an error?
Hi there,
Can you tell us the error message that you get?
Thanks,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
T
On 17/07/2012 17:37, Raymond O'Donnell wrote:
> On 17/07/2012 14:14, Zhang, Nancy wrote:
>> Thank you Ray.
>>
>> There isn't any file named pgpass.conf in my computer after my
>> searching attempt. Is there any other reasons? And is there a way
>> th
nd then is
deleted at a later point, you need to find out what's deleting it; from
what I understand it's unlikely to be pgAdmin.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make chan
it works, and
> suddenly it doesn't remember your password. There's nothing I can do
> about this. If you find why it forgets your password, then I may be able
> to do something.
Passwords are stored on Windows under /AppData/Roaming/postgresql/pgpass.conf - could something be
del
query is
running? Is the timer in the lower right corner of the window incrementing?
You probably know this, but just in case: plain-text backup files from
pg_dump don't as a rule work in a pgAdmin query window, as they contain
various psql-specific backslash commands that pgAdmin doesn't han
[sorry - didn't cc the list].
Original Message
Subject: Re: [pgadmin-support] Demande de support
Date: Wed, 27 Jun 2012 15:47:16 +0100
From: Raymond O'Donnell
Reply-To: r...@iol.ie
To: Wajdi Dhaouadi
On 27/06/2012 15:42, Wajdi Dhaouadi wrote:
> support
>
>
On 27/06/2012 14:56, Wajdi Dhaouadi wrote:
> Merci de m'envoyer un support .
Certainly - what is your issue?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subsc
pp-psql.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
y.
I could be wrong, but I think that that button is Windows-specific;
PgAdmin is a cross-platform tool.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
the list owner will help you.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
onnect to one that isn't
started. They'll be on different ports.
I don't know what else to suggest, but that's the area to investigate
anyway...
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgre
hat server is actually running?
What platform(s) are you on?
You should know also that 8.1 is a VERY old version of PostgreSQL, and
is no longer supported, meaning that it no longer gets bug fixes.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-suppor
On 22/03/2012 16:27, Yamato Suemitsu wrote:
> Platform: Windows 7 Ultimate, x86 32 bit
> I have reinstalled pgAdmin.
> I forgot the password for the system account.
In that case, you use the normal Windows tools to reset it.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@io
roceed?
It doesn't matter about pg_hba.conf - no passwords are stored there, it
just sets access rules about who can connect, from where and how.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
ain give me further information on using Primary Keys in postgreSQL
> (and pgAdmin). The same case with the foreign keys.
Any tutorial on databases will explain PKs and FKs much better than I
can; they're not specific to Postgres.
HTH,
Ray.
--
Raymond O'Donnell :: Galway :: Ire
On 17/02/2012 10:55, Dave Page wrote:
> On Fri, Feb 17, 2012 at 10:54 AM, Raymond O'Donnell wrote:
>> On 17/02/2012 09:50, chifa arsy wrote:
>>> Dear pg support admin
>>>
>>>
>>>
>>> I need some help from you..I have to install ISS enter
On 17/02/2012 09:50, chifa arsy wrote:
> Dear pg support admin
>
>
>
> I need some help from you..I have to install ISS enterprise
> release 6 in my laptop. I want to ask you, how to create a database in DDI
> for ISS??
>
What is IIS?
Ray.
--
Raymond O'D
l or remote?
- What errors or other messages do you get?
- Do you have the necessary permissions on the table?
etc etc etc...
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your su
On 08/02/2012 22:42, Anna Leslie wrote:
> Hello,
>
> I just installed postgres, phppgadmin onto a Mac OS 10 and cannot login on
> pgadmin server page.
A bit more information would help... in particular, what error message
are you getting?
Ray.
--
Raymond O'Donnell :: Ga
o the query
tool, which can be handy if you need it a lot. It's under File ->
Options -> Query Tool tab, "Copy SQL from main window to query tool".
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-s
D NONE OF THIS IS IN THE
> DOCUMENTATION !!!
The "server" in the PgAdmin tree view relates to a a specific
postmaster, listening on a specific port and/or Unix socket, on a
specific machine.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
t let you straight in without any authentication ("trust").
Remember too that the order of rules in pg_hba.conf is important - the
first matching rule will take effect.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
and look at the *Open with* menu, I don't see
> pgAdmin III even listed.
Hi there,
It works for me, on Windows 7 - pgAdmin registers itself against the
.sql extension.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-sup
Admin is on the same machine as the
database server, then you can also enter 127.0.0.1 or "localhost"
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
to allow
access from all hosts on a subnet with mask 255.255.255.0, it would be
192.168.1.0/24.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
t edit the
real one, which ought to be in the PostgreSQL data directory - I can't
remember where it goes by default (I've put mine somewhere
non-standard), but it might be:
C:\Program Files\PostgreSQL\9.1\data\pg_hba.conf
If you've already changed settings in postgresql.conf, it
ake wrong?
Try leaving the "Service" field blank and see what happens.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 25/11/2011 13:10, TAHRAOUI Lyamine wrote:
> Hello,
>
> Would - it possible to have a documentation of the Pg admin?
>
> thank you very much
Bonjour,
On my platform (Windows 7), PgAdmin comes with built-in help: on the
"help" menu, click "Help contents&
ere, and I don't see a menu entry for it on
> the View menu. Is there a key somewhere I can toggle to get it to
> be disabled/hidden?
Why on earth would you want to? :-) It sounds really useful.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadm
gresql IRC channel on irc.freenode.net. See
> the PostgreSQL FAQ for more information.
There's also a good bit of stuff on the wiki.:
http://wiki.postgresql.org/wiki/Category:Replication
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-sup
On 14/03/2011 17:35, Vladimir Kokovic wrote:
Hi,
I intend to implement the following features that are lacking in pgAdmin3:
1. copy / cut / paste schema
2. copy / cut / paste table
What do you think?
Can you elaborate a bit more?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@i
you.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
could then
use diff on the resulting files - would that do the job?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
that you can do this, unless you are hacking the
pgAdmin C++ code.
Why not just use psql and pipe the output to a file or something?
Anyway, what exactly are you trying to achieve?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadm
log to
see if there's anything there?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
e the name of the role you
want to use to login.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 18/12/2010 11:40, Guillaume Lelarge wrote:
Le 18/12/2010 11:58, Raymond O'Donnell a écrit :
On 18/12/2010 02:06, jak wrote:
How do I set tab size on sql editor? The default size seems is 8 which
take
too much width on a line.
File -> Options -> Query tool tab -> Ind
On 18/12/2010 02:06, jak wrote:
How do I set tab size on sql editor? The default size seems is 8 which take
too much width on a line.
File -> Options -> Query tool tab -> Indent characters.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-suppor
ith.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
begin
x := 7;
select * into rec from site where sitecode = x;
end;
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On 22/10/2010 12:02, Thom Brown wrote:
However, I have noticed an extra level of sheen in this version. Have
you guys changed something? The tabs look shiny and the toolbar looks
less bulky.
I get that effect when I clean the dust off my monitor... :-P
Ray.
--
Raymond O'Donnell :: G
of how it
looks on mine (Windows 7).
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
<>
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
is also used as a default template when new databases are
created, so having a separate "postgres" database keeps things tidy.
I hope that this makes sense. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
1 - 100 of 294 matches
Mail list logo
