On Tue, Sep 15, 2015 at 12:28 PM, HEARNE, TIMOTHY S wrote:
> This is my second plea for assistance. Can anyone assist me? I have
> attempted to download a couple of different tools from the PostgreSQL
> site. One would not compile on our server, pg_top-3.7.0, and another was
> targeted for Pos
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
On Tue, Nov 1, 2011 at 07:23, Guillaume Lelarge wrote:
> [...]
>
> With 10k rows (2.3 MB) it took 3.5 seconds to retrieve data from DB and 40
> > seconds to write the file to an SATA 7200 disk with write-through cache.
> > With 100k rows (23 MB) the DB retrieve went for 35 seconds while the file
>
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?
>
> --
> Regards,
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-hoc basis, I could increase the si
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 / paste table
> copy / c
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
Hi Chris. It seems you preformed a data-only backup as the log provided
doesn't show DDL sentences.
Having done so could face you with two problems:
1. The destination database schema is different than the one where you
performed the backup. The error reported on table alert_request seems to
confir
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
On Wed, Dec 23, 2009 at 15:39, Nicole Lim wrote:
> Hi there,
>
> I have problem to add server by using the IP address like 192.168.xxx.xxx.
> It says the server refused to listen. I followed the guide by adding the
> line at the pg-hba but still the same.
> Also, when I'm using the psqlodbc from
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
On Wed, May 6, 2009 at 11:30 AM, calibration wrote:
> Dear Support,
> We have Postgresql 8.1
> It is the default database installed with our temperature datalogger
> LogWareIII from Hart Scientific.
>
> I have some troubles with this software and I have tried to enter in the
> PostgreSQL software
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
On Wed, Apr 1, 2009 at 4:27 AM, Dave Page wrote:
> Dear pgAdmin Community,
>
> You may be aware that the pgAdmin project has been in existence for
> nearly 11 years now. During this time, the development team have spent
> thousands of hours writing hundreds of thousands of lines of code and
> doc
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.
Marco,
Esta es una lista sólo en inglés específica de pgAdmin. Por favor publica
tus preguntas sólo en ese idioma. Para obtener ayuda en español puedes
suscribirte a: http://archives.postgresql.org/pgsql-es-ayuda/
La interfaz del administrador -te refieres a pgAdmin- es independiente de la
base d
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.
>
On Wed, Aug 6, 2008 at 10:46 AM, Dave Page <[EMAIL PROTECTED]> wrote:
>
> pgAdmin does include the context line, if the server gives us one:
>
> -- Executing query:
>
> select foo();
>
> ERROR: division by zero
> CONTEXT: PL/pgSQL function "foo" line 4 at assignment
>
Hi Dave. Since you mention
El problema que tienes es que tu versión de pg_dump difiere del de la base
de datos (8.3.0 vs 8.3.3). Lo solución es que actualices pg_dump a la
versión 8.3.3.
De todas maneras podrás hacer el backup desde linea de comando agregando la
opción -i para que pg_dump ignore las diferencias en versión c
On Tue, Jun 24, 2008 at 4:17 AM, Ryan Daniels <[EMAIL PROTECTED]>
wrote:
>
> I would like to request that the SQL query window have tabs so that you can
> have multiple queries/files open in the same window.
>
>
Agreed. That would be a nice feature to see in the next release.
And also an option/se
>
>
> 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,
> > >
> > >
On Tue, Apr 8, 2008 at 3:29 AM, Julius Tuskenis <[EMAIL PROTECTED]> wrote:
> Hello.
>
> What do you mean saying CONTEXT messages? Could you give an example what
> you get and what you want to get from your functions?
>
>
>
Sure. I have made a simple example to show this with 2 functions: f_outer
w
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.
39 matches
Mail list logo
