nes with write access can written back to config files.
Andrus.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
te those requests to file system calls itself.
Andrus.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
t;postgresql.conf": No such file or directory
CONTEXT: SQL function "pg_file_length" statement 1
STATEMENT: SELECT pg_file_read('postgresql.conf', 0,
pg_file_length('postgresql.conf'))
How to edit conf files from pgAdmin in this case?
Andrus.
--
Sent via
Are you on a domain with any policies in place that could be affecting
things?
There is no domain.
I bought new computer with Vista Business pre-installed, installed
PostgreSQL 8.2.3
and pgAdmin from your link.
Andrus.
---(end of broadcast
d Postgres and
pgAdmin from you link and some other software.
Anything odd about your setup?
I have disabled visual effects (selected optimize for perfomance in control
panel).
I use non-english regional settings.
Andrus.
---(end of broadcast)-
Please try this dev snapshot
http://www.pgadmin.org/snapshots/win32/pgadmin3-20070612.msi
Dave,
thank you.
I tried it but results are rhere same: zero size file is created in disk and
nothing more happens.
Andrus
---(end of broadcast
and with
http://www.pgadmin.org/snapshots/win32/pgadmin3-20070612.msi with Windows
Vista.
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
How to change order of lines in pg_hba.conf file
using pgadmin Backend Access Configuration Editor ?
Order of lines in this file is very important.
I havent found any way.
Andrus.
---(end of broadcast)---
TIP 1: if posting/reading through
tware installed.
I looked into download page and haven't found 1.7-dev binaries for Windows.
Should I try 1.6.3 ?
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if yo
OK.
Using 1.6.2
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
What version are you running? That was fixed prior to 1.6 -
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi?rev=5490&view=rev
And it still works in 1.6.2 and trunk.
I'm using 1.6 beta 3 in XP.
Andrus.
---(end of broadcast)---
TIP 3: Have yo
If I press Ctrl+F in Query window, Cancel button is active.
Can you change find dialog, that Find what: field is active by default like
in other applications, please.
Andrus.
---(end of broadcast)---
TIP 7: You can help support the
be present
Remarks:
1. pg_get_indexdef() returns text_pattern_ops . I'm wondering why pgAdmin
does not use this.
2. Similar issue with bpchar_pattern_ops is fixed, thanks.
Andrus.
"PostgreSQL 8.2beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(min
Currently pgAdmin allows to delete only emtpry schemas.
Can you add CASCADE clause to the DROP SCHEMA statement which pgAdmin
generates so that non-empty schemas can be deleted also, please.
Andrus
---(end of broadcast)---
TIP 9: In versions
I see both.
> And the column gets deleted just fine!
>
> What is your database encoding? I tested with latin1 and utf8.
My database encoding is UTF8
Cluster and Windows locales are Estonian
Andrus.
---(end of broadcast)---
TIP 7: Y
olumn name must be shown.
Word text must be fully visible.
Version: 1.6beta3
Platform: XP SP2
Andrus.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
s Ubuntu comes
>with almost all the >prerequisites. You might have to install the dev
>versions of pg stuff and wxWindows.
Can you create a .deb package for install ?
or Is there some step by step installations for doing this in kubuntu ?
Andrus.
---(end of br
I installed pgadmin using kubuntu package manager.
This installs pgadmin 1.2.2
How to install latest pgadmin in kubuntu ?
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Platform:
PgAdmin 1.4.0 on Windows XP with Postgres 8.1
Andrus.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
e _popen function returns an invalid
file pointer that will cause the program to hang indefinitely. _popen works
properly in a Console application. To create a Windows application that
redirects input and output, see Creating a Child Process with Redirected
Input and Output in the Pla
cd "C:\Document and settings\ postgres\Local Settings\temp\pda48EB.tmp"
>
> 1_1.bat
>
>
> and pg_dump.exe creates backup file
>
>
> So running 1_1.bat manually as user postgres works OK.
Application log contains
Could'nt execu
es\Local Settings\temp\pda48EB.tmp"
1_1.bat
and pg_dump.exe creates backup file
So running 1_1.bat manually as user postgres works OK.
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
es is member of the
following groups:
Account Operators
MYCOMPANY
Domain Computers
Domain Controllers
Domain Users
Pre-Windows 2000 Compatible Access
Server Operators
Users
Andrus.
---(end of broadcast)---
TIP 4: Have you searched ou
e.
Filemon log included.
I also entered direct call to pg_dump.exe into definition window but
error message is the same.
Andrus.
begin 666 Filemonterve.zip
M4$L#!!0(`(*1D30']DVA[ 0G?UM]\46YH(<.Q9VTEV
M``.!XMPXPLJ61U)FDEWL_[Y-VA)YQ3J\'^RSEA_R$-A]6,7N7U?S%'GM(YN?
M6/-$RJ-/E
> Here is filemon log with filter pgagent
Full log (without any filters applied) is added to this letter.
Andrus.
begin 666 unfiltered.zip
M4$L#!!0(`+F2[;,W8O\#GS="C*H"ZLMOLDC9BBN3NJ)L
[EMAIL PROTECTED](*26S)C*%)#TAY[-G9^^ZVN)JNK"IFG`&2BFWZ8\8<:IY#(/ `2!XG\
MF[S
> Hmm, nothing useful there then. OK, can you grab filemon from
> www.sysinternals.com and try to capture the job failing please? With a
> little luck it'll show what filesystem operation is actually failing.
Here is filemon log with filter pgagent
1 19:17:08 pgagent.exe:2588 OPEN C:\DOCUME~1\po
> Can you reinstall the agent service with the '-l 2' option (no quotes)
> and see if anything useful gets logged in the event log please?
Here is application log:
13.04.2006 17:46:25 pgAgent Information None 0 N/A STAR Clearing inactive
connections
13.04.2006 17:46:15 pgAgent Information None 0
Good point.
I receive error that could not execute
C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
and error code is -1
How to solve this problem ?
Andrus.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an ap
tgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
> exist, and if so what's in it?
This directory does not exist.
Only C:\DOCUME~1\postgres\LOCAL~1\Temp directory exists.
I verified, user postgres has Full Control rights to C:\DOCUME~1\postgres
directory.
Andrus.
--
gent allows me to monitor backup status remotely using pgadmin or
making sql queries to
pgagent schema, without need to log-in and open RDP port in server.
So I'd prefer to use pgAgent even for simple backup if possible.
Andrus
---(end of broadcast)--
.bat
Any idea how to make automatic backup at 3:00 every night in W2K server ?
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
>> Couldn't execute script
>> C:\DOCUME~1\postgres\LOCAL~1\Temp\pgaD591.tmp\1_1.bat
>
> Try to run CMD explicitely.
I changed definition window to
cmd /C c:\mydir\mybackup.bat
but error message remains the same.
pgagent tries to execute
very night ?
Environment:
Postgres 8.1.3
PgAdmin 1.4.2
Windows 2000 server
Andrus.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that yo
Relation column in Locks page of PgAdmin III Server Status Window shows
only relation number.
How to see relation names instead of relation numbers in this column ?
Is'nt it more reasonable to show names in pgAdmin ?
Andrus.
---(end of broa
that I should install server management
instrumentarium but gives no help how to install.
How to install server management instrumentarium without compiling in
Windows 2003 server ?
Andrus.
---(end of broadcast)---
TIP 2: Don't 'ki
. How to subscribe this list without receiving e-mail
like in Postgres mailing lists.
I tried subscribe-nomessage but this fails.
Andrus.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
editing ?
It seems that wxWidgets cell editor does'nt let to use arrow keys for grid
navigation.
Andrus.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
haracters, not from center.
It seems that if text width is greater than column width column alignment
is changed dynamically to left and changed back to center if column is
resized to be wider.
wxGRID does not support this, right ?
Andrus.
---(end of broadcast)-
> This has been fixed in SVN trunk.
I looked into changelog but havent found any information.
What is the file name or revision number where this was fixed ?
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
, maybe this can
be used as quick fix ?
Andrus.
Platform:
Windows XP
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
#x27;'" in connection info
string
Platform:
pgAdmin 1.4.0 on windows xp
PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)
Andrus Moor
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ng pgadmin should terminate pg_dump and pg_restore also
Platform: 1.4.1 on XP
Andrus.
---(end of broadcast)---
TIP 6: explain analyze is your friend
"No, pgAdmin always works in ISO format, except in the query tool. That is
by design."
pgAdmin uses three different date formats:
1. Localized date format in query designer
2. ISO format in query output and in sql window
3. US format in date entry fields like in Login Role properties Account
exp
: Windows XP SP2
Andrus
---(end of broadcast)---
TIP 6: explain analyze is your friend
any place.
2. utils\precomp.cpp
3. pgadmin3.rc
This causes VC++ 6.0 build to fail.
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column&#
Panel / Regional and Language options window.
Note:
wxWidgets 2.6.2 Calendar sample application Date Picker control shows
expected results.
Version: 1.4.1
Platform: Windows XP SP2
Andrus.
---(end of broadcast)---
TIP 9: In versions below 8.0, the
To reproduce:
1. Run command
CREATE ROLE test CREATEROLE
2. Look to the role definition in Group roles.
Observed:
CREATE ROLE test
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
Expected:
CREATE ROLE test
NOSUPERUSER INHERIT NOCREATEDB CREATEROLE;
Platform:
PgAdmin 1.4.1 on Windows XP
dmin works like vkontoklas column is primary key !
Andrus
---(end of broadcast)---
TIP 6: explain analyze is your friend
umnr = nextval('demo.'||TG_RELNAME || '_'|| NEW.doktyyp ||'_seq');
error does not occur.
Is this PgAdmin bug ?
How to fix this without adding schema name to nextval() argument ?
Andrus.
Code to reproduce:
CREATE SCHEMA demo;
SET search_path TO demo,public;
49 matches
Mail list logo
