* Sergey Arlashin wrote:
In section 'Making a Base Backup Using the Low Level API' is said that
once one has WAL archiving set up it is ok to omit pg_xlog folder from
the backup dump:
You can, however, omit from the backup dump the files within the
cluster's pg_xlog/ subdirectory. This slight
* Scott Whitney wrote:
Everything you need to see is right here:
[root@serverNameRemoved pg_log]# ls -lrt
total 5924
-rw--- 1 postgres postgres 708669 Aug 8 18:59 postgresql-Thu.log
-rw--- 1 postgres postgres 669505 Aug 9 18:59 postgresql-Fri.log
-rw--- 1 postgres postgres
* ramana...@gmail.com wrote:
We have a unix group mhubrpt on DB2 unix server and have connect permissions
to DB2 database for that group.
Whenever user needs access to DB2 database we will add that user to DB2 unix
server and assign to group mhubrpt, then user was getting access to DB2
* Babay Adi, Hava wrote:
On the same regard – Some of the mentioned modules in the mentioned
application use a set of tables which is logically separate (there are
no join statements with tables of other modules). What are the pros\cons
of using a separate database instead of a separate schema
Hello all,
I get the following output from pg_upgrade when trying to upgrade a
test cluster on Windows 7 x64:
c:\Datenpath
PATH=c:\windows;c:\windows\system32;c:\Program Files\PostgreSQL\9.2\bin
c:\Datenpg_upgrade --old-bindir=c:\Program Files\PostgreSQL\9.1\bin
--new-bindir=c:\Program
* Bruce Momjian wrote:
On Thu, Sep 13, 2012 at 02:15:00PM +0200, Christian Ullrich wrote:
c:\Datenpath
PATH=c:\windows;c:\windows\system32;c:\Program Files\PostgreSQL\9.2\bin
c:\Datenpg_upgrade --old-bindir=c:\Program Files\PostgreSQL\9.1\bin
--new-bindir=c:\Program Files\PostgreSQL\9.2\bin
* Craig Ringer wrote:
On 06/16/2012 08:36 PM, Christian Ullrich wrote:
The one-click installer (assuming you used that) left you with
PostgreSQL running under a local account named postgres. First, you
have to change that, because SSPI requires that the service uses a
domain account
* Peter Cheung wrote:
I’m new to PostgreSQL. I installed PostgreSQL on a Windows Server 2008
R2 server. I have created a database and an user in Windows Active
Directory. How can I configure that user to access that database?
The one-click installer (assuming you used that) left you
* Peter Cheung wrote:
I have installed Postgresql using One click installer on a Windows
Server. How can I check whether GSSAPI support is enabled so I can use
SSPI for Windows Authentication?
GSSAPI support is not enabled in the one-click installer, but you also
do not need it for SSPI.
lines, so you
can get in even if it does not work right.
7. Start the PostgreSQL service.
You can use the klist command on the clients to check whether they
get service tickets from the domain controller.
Good luck.
--
Christian Ullrich
--
Sent via pgsql-admin mailing list (pgsql
* Josef Springer wrote:
we are using PostgrSQL 8.1 and the client is connected via ODBC
PostgreSQL Unicode.
What must be used to use the install ODBC on a Windows-64 system ?
The latest release of the 32-bit ODBC driver appears to be
* Gnanakumar wrote:
We're using PostgreSQL v8.2.3.
How do I get the schema name in which TEMPORARY table is created using
CREATE TEMP TABLE mytable syntax?
SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();
I don't have an 8.2.3 lying around, but git says that function
* Adarsh Sharma wrote:
I am able to execute command successfully through CLI or pgAdmin .
*create table user_news_new as select
record_id,field_name,field_value,news_date from user_news where
field_name in ('SOI','RelLoc','Description','Heading','news_date') and
field_value != '' ; *
But I
* Brian Fehrle wrote:
CREATE LANGUAGE plperl;
ERROR: could not load library C:/Program Files
(x86)/PostgreSQL/8.3/lib/plperl.dll: The specified module could not be
found.
I looked in that location and the plperl.dll does exist. I checked
permissions, both the user account postgres and the user
* Anuj Pankaj wrote:
Please help to run my postgres on remote manchine through pgAdmin III.
Do you have a firewall on the database server or anywhere between your
Windows client and the database server that might be blocking the
connections?
--
Christian
--
Sent via pgsql-admin mailing
Hello all,
I'm having a problem using GSS authentication with PostgreSQL 8.4.4 on a
Windows 2008 server. I need GSSAPI instead of SSPI for the JDBC driver.
We are using SSPI with the ODBC driver at the moment, and it works fine.
The problem is this: For three days in a row now, I have tried
16 matches
Mail list logo