Hi Melvin,
Thanks for your answer and yes I forgot to attach my image,
But I found a solution to my problem,
I changed lc_messages in my postgresql.conf file and it stay like this
lc_messages = 'en_US.UTF-8'
Now is functioning.
Thank you!
Fernando
Hello List!,
I am trying to query server status in PgAdmin III 1.14.3 on Windows 10 and
postgres database 9.1 version
and I have this error message "invalid byte sequence for encoding "UTF8"
I attached an image, somebody have some idea?
How could resolve this problem?
Regards,
Fernando
Hello,
I've installed Pgadmin3 with the following command: *sudo apt-get install
pgadmin3,* but its not launching. When I try it using the terminal I have
the following:
*Fatal Error: Mismatch between the program and library build versions
detected.The library used 2.8 (no debug,Unicode,compi
at a greater overhead cost).
Please, don't follow up here. Ask in the postgres Administration list and
someone will be able to explain why your postgres DB configuration uses
this amount of RAM.
Fernando.
Lista equivocada amigo. Esta es de pgAdmin, un gestionador gráfico de
Postgres. Además es en inglés únicamente.
Para preguntas sobre Postgres en español:
http://archives.postgresql.org/pgsql-es-ayuda/
De todos modos, el error te está indicando un posible cambio de permisos
sobre el archivo pg_xlog
On Mon, Nov 26, 2012 at 9:55 AM, Andrew Taylor
wrote:
> [also posted to Django users Google group]
>
> Hi all,
>
> Can I bypass the need for password entry in pgadmin3 by
> changing/locating/permissioning a .pgpass files instead of modifying
> pg_hba.conf to 'trust'? pg_hba.conf currently set at m
On Tue, Jul 17, 2012 at 3:52 PM, Guillaume Lelarge
wrote:
> On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro wrote:
> > No, it doesn't.
> >
> > For example, I want to see if a given string is used within a function.
> > I want to be able to see all the uses of a function: in other functions,
> i
Wrong list. This is a pgAdmin discussion list (graphical Postgres front-end
client).
You should post your questions in one of the following PostgreSQL related
lists, probably pgsql-admin or pgsql-bugs:
http://www.postgresql.org/community/lists/
Regards.
On Fri, Jan 20, 2012 at 04:10, paddy carro
Cristian,
Esta lista es exclusiva de pgAdmin (un cliente gráfico para Postgres) y tu
pregunta es respecto a la base Postgres.
Básicamente debes:
1. Instalar Postgres en la PC de tu cliente.
2. Hacer un backup de la base en tu PC (pg_dump)
3. Hacer un restore en la base de tu cliente (pg_restore).
Buen día. Esta es una lista específica de pgAdmin, un cliente gráfico para
conectarse a PostgreSQL.
Tu consulta es de PostgreSQL por lo que debieras plantearla en la lista
pgsql-es-ay...@postgresql.org
si quieres hacerlo en español, o a pgsql-gene...@postgresql.org en inglés.
Saludos,
Fernando
On Thu, Nov 3, 2011 at 08:20, Guillaume Lelarge wrote:
>
> OK, found it. We introduced some time ago a cache for type lookup. It
> seems the boolean type doesn't make it to the cache. The patch is
> commited. It should be available with the release of 1.14.1.
>
>
Nice.
Thanks for fixing this. Exce
how I was completely underrating the workload involved in the file
writing process.
> I searched if there were some parts that took much longer than others,
> but failed to find one.
>
The effort is much appreciated. Thanks.
Regards,
Fernando.
Hello.
I could reproduce the issue in a fresh Windows 7 install with no other apps
running other than pgAdmin v1.14.0.
>From what I could see, the execute-to-file function runs in 2 stages:
1. Rows are retrieved from DB server to RAM
2. Rows are written from RAM to file
The delay clearly occurs i
On Wed, Oct 12, 2011 at 18:02, Guillaume Lelarge wrote:
> On Wed, 12 Oct 2011 17:02:59 -0300, Fernando Hevia
> wrote:
> > Bob, I was going to suggest you get rid of that weird mouse of yours but
> > it wont be necessary as Ctrl-+ and Ctrl-- already work as
> > suggested
Bob, I was going to suggest you get rid of that weird mouse of yours but it
wont be necessary as Ctrl-+ and Ctrl-- already work as suggested. At least
in v1.14.0 it does.
:)
On Wed, Oct 12, 2011 at 16:30, Guillaume Lelarge wrote:
>
> Sure. If you know a better UI, we can probably make that happ
Hi.
You can use Control key + mouse scroll wheel for instant resizing.
For a permanent setup take a look in the File->Options menu.
Regards,
Fernando.
On Wed, Oct 12, 2011 at 08:10, Aleksey Chirkin wrote:
> Hello!
>
> Tell me please, how can I change font in SQL pane window?
>
It does for me.
I am using 1.14 beta1
First change the setting and then open an sql window. Both text window and
results grid *contents* should show with the new font size.
On Wed, Sep 7, 2011 at 00:52, Josh Berkus wrote:
> On 9/6/11 6:17 PM, Fernando Hevia wrote:
> > You can change
You can change the font size from: File->Options->Query Tool->Font menu.
Regards,
Fernando.
On Tue, Sep 6, 2011 at 21:40, Josh Berkus wrote:
> Folks,
>
> I'm going to be doing a demo, on video, using pgadmin tommorrow night.
>
> Is there any way, even on an ad-ho
Not sure if available in v1.12 but in 1.14 you can change the quote
character at your leisure from File -> Options -> Query tool -> "Result copy
quote character".
Cheers.
On Sat, Aug 27, 2011 at 10:58, Colin Beckingham wrote:
> Using Opensuse 11.4 Kernel 3.0, pgadmin 1.12.3
>
> In the query too
I think those features would be a nice addition.
Regards,
Fernando.
On Mon, Mar 14, 2011 at 15:10, Vladimir Kokovic
wrote:
> Hi,
>
> Intended function:
>
> 1. copy / cut / paste schema
> copy / cut all schema objects to destination database.schema
> 2. copy / cut / p
2010/11/10 Guillaume Lelarge
> Le 03/11/2010 19:08, Robert Galeano Fernandez a écrit :
> > Hola, por que no permiten que se modifiquen las opciones de parametro de
> una
> > funcion a travez del pgadmin ..??? es una mierda que no te permita
> hacerlo
> > visualmente en el año 2011 ya casi y tenem
¿What happens if you run the same select from pgAdmin or psql?
On Thu, May 27, 2010 at 16:46, Kevin Kempter wrote:
> Hi All;
>
> We have a local postgres database (8.3.x) with an application / web front
> end
> pulling data from it. THe database server is on the east coast, we also
> have
> a re
ms to
confirm this.
2. You probably already have data on the destination database which triggers
the unique key contraints.
If this proves to be the case you should check your schema is identical to
the original one. Then truncate all tables before restoring data.
Regards,
Fernando.
On Thu, Apr 22, 20
You could also disable "Read and write Unicode UTF-8 files" in
Options->Preferences.
It will not write a BOM but you will not have UTF-8 either.
On Thu, Apr 22, 2010 at 07:29, John Gage wrote:
> Additionally, if the Vim option "bomb" is set to "nobomb" it will strip the
> BOM. This solves my "
Well... I don't use it either. The only place I have used anything like a
graphical query builder (or wizard) was in MS Access, but thats just because
of the crazy sql syntax that thing has.
Instead of the query builder feature I rather had many sql window tabs.
Cheers.
On Sun, Feb 21, 2010 at 0
ify the line you added to pg_hba.conf looks like this:
hostall all 192.168.0.0/16 md5
This will enable a client from network 192.168.x.x to connect with any user
to any database. MD5 password check will be enforced.
Regards,
Fernando.
On Fri, Sep 11, 2009 at 4:16 AM, andre.wasserman telkom <
andre.wasser...@telkomsa.net> wrote:
> Dear PG Admin
>
> I downloaded Win AllinOne and seperate Client/Server/Postgre installation.
> Tried Allin in one on a clean PC, but still can't get things going.
>
> On the clean PC everytime, when e
d5
Restart the postgres service and you are back on track hopefully.
Regards,
Fernando.
On Sun, Apr 5, 2009 at 10:09 PM, Just E. Mail wrote:
> Rod:
>
> I forgot to mention that I am a VERY VERY newbie. So what you wrote below
> is fine except I have no idea what it means.
>
> In any case I did go to URL:
> http://yum.pgsqlrpms.org/8.3/redhat/rhel-5server-i386/
> however at this site
his time drinking wine in his new vinyard
> at Château Margoux.
Raising sheep... lol.
> I'd like to thank all of our users and contributors over the past 11
> years - it's been an absolute pleasure working with all of you.
>
You are most welcome :)
It has been -and still is- an absolute pleasure to use this fine
application.
Best regards,
Fernando.
On Sat, Mar 14, 2009 at 6:38 PM, Dave Page wrote:
> On Sat, Mar 14, 2009 at 8:28 PM, Fernando Hevia wrote:
> > Hi list,
> >
> > Is there in 1.10 any way to hide temporary schemas (pg_temp_xx &
> > pg_toast_temp_xx) from the treeview?
> > If there isn'
Hi list,
Is there in 1.10 any way to hide temporary schemas (pg_temp_xx &
pg_toast_temp_xx) from the treeview?
If there isn't, it would be great if this feature could be considered for a
future patch.
BTW, congratulations to all devs for the new release!
Regards,
Fernando.
sh you can
suscribe to http://...
The administrator's interface -you mean pgAdmin- is an independent software
from the database and is licensed under what is known as the "artistic
licence". Its definition is here: http://...
--
Saludos,
Fernando.
On Mon, Jan 12, 2009 at 10:05 PM, Marco
On Thu, Sep 4, 2008 at 4:37 AM, Dave Page <[EMAIL PROTECTED]> wrote:
> On Thu, Sep 4, 2008 at 7:19 AM, Ben <[EMAIL PROTECTED]> wrote:
> > Why is pgAdmin so crap?
>
> Yeah, unfortunately that's a side effect of the polymorphic user
> interface which adapts itself to the capabilities of the user.
>
so bad
that it makes them unreadable.
I am aware its not a critical request at all, but it would be nice to
see it included in the to-do list for some future version.
Regards,
Fernando.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
s and
Settings\dayala\Escritorio\db_dgcp1.backup" db_dgcp080708
Por cierto, esta es una lista en inglés. Debieras formular tus consultas en
dicho idioma para obtener más y mejores respuestas.
Saludos,
Fernando.
On Mon, Jul 14, 2008 at 12:38 PM, Diego Ayala <[EMAIL PROTECTED]> wrote
e.
And also an option/setting to filter server context messages.
Doable or not, I want to thank the developers for their great work on this
project!
Regards,
Fernando.
>
>
> Regardless of your request about silencing context messages (did not
> look into that): maybe SQL along these lines would do the job for you?
>
> select id_cliente, array_to_string(ARRAY(SELECT apellido from clientes
> c0 WHERE c0.id_cliente = c.id_cliente), E'\n')
> from clientes c
> group b
On Tue, Apr 8, 2008 at 3:22 AM, Guillaume Lelarge <[EMAIL PROTECTED]>
wrote:
> Fernando Hevia a écrit :
>
> > On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED] > [EMAIL PROTECTED]>> wrote:
> > > Hi list,
> > >
> > >
client, r_clients.apellido;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
CREATE OR REPLACE FUNCTION f_outer() RETURNS void AS
$BODY$
DECLARE
r_clients clientes%ROWTYPE;
BEGIN
FOR r_clients IN SELECT * FROM CLIENTES
LOOP
RAISE NOTICE 'f_outer: %', r_clients.id_cliente;
PERFORM f_inner(r_clients.id_cliente);
END LOOP;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Regards,
Fernando.
On Mon, Apr 7, 2008 at 8:55 PM, Fernando Hevia <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> How do I remove CONTEXT messages from being displayed in pgadmin?
> Those messages clutter my functions output with information I dont need so
I
> would like to get rid of them.
>
>
Hi list,
How do I remove CONTEXT messages from being displayed in pgadmin?
Those messages clutter my functions output with information I dont need so I
would like to get rid of them.
Is that possible?
Thanks,
Fernando.
Hello,
they excuse by my ingles, but , I am using fields
to varchar with types,
and it happens that it always takes them from a
length of 254.
I am using postgresql on 8,00 Windows 2000 and
pgadmin III 1.2
Greetings, Fernando Aguada
Greetings!
I've just installed pgAdmin3 1.2.0-beta1 binary for Slack 9 on Slack 10
using pkgtool, it did install and is running very well.
Now, I'm also using pgAdmin3 1.1.0 Devel (Aug 19 2004) on Fedora Core 2.
As no binaries of the new beta are available for FC2, I tried compiling
it from source
Hi all!
Are there any pgadmin3 binary for FC2 already?
I've been trying to build it from source with no success.
Thanks a lot! ;-)
--
Fernando J. Leal
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.ingeni
1.0-cvs20031211)
--
Fernando J. Leal
[EMAIL PROTECTED]
http://www.ingeniumatica.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
xplanation at all - it simply disappears. (I'm
running it on Fedora Core 1.)
Can anyone else please confirm it?...
Fernando J. Leal
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.ingeniumatica.com
---(end of broadcast)---
TIP 3
Greetings!
pgAdmin3 doesn't work on Fedora Core 1 after updating from Red Hat 9
like it used to because libcom_err.so.3 is not included in the Kerberos
packages Fedora now uses.
Would it be possible for someone to build a pgAdmin3 RPM for Fedora? I
tryed, but I miss some libraries needed to co
48 matches
Mail list logo
