Στις Friday 30 May 2008 07:35:19 ο/η kevin kempter έγραψε:
Hi list;
I'm trying to get postgres syslog to get along with no luck. I'm
running freeBSD7 and postgres 8.3.1
Here's my postgres setup
log_destination = 'syslog'
#logging_collector = off
syslog_facility = 'LOCAL0'
did you kill -hup syslogd after you changed syslog.conf
On Thu, May 29, 2008 at 11:04 PM, Achilleas Mantzios
[EMAIL PROTECTED] wrote:
Στις Friday 30 May 2008 07:35:19 ο/η kevin kempter έγραψε:
Hi list;
I'm trying to get postgres syslog to get along with no luck. I'm
running freeBSD7
1) syslog.conf:
!postgres
*.* /var/log/postgresql.log
2) in your root shell:
touch /var/log/postgresql.log
3) don't forget newsyslog.conf
4) don't forget man syslog.conf
On Thu, 29 May 2008 22:35:19 -0600
kevin kempter [EMAIL PROTECTED] wrote:
Hi list;
I'm trying to get postgres
I have a database that is in ASCII character encoding. How do I go
about migrating it to UTF8?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
My e-mail address has changed to
Hi,
I am using Solaris 10 5/08 x86. I have downloaded the 8.3 binary and
install in under /usr.
When I initdb by su postgres:
$ /usr/postgres/8.3-community/bin/64/initdb -D /var/lib/pgsql/data
output:
ld.so.1: initdb: fatal: libxslt.so.1: open failed: No such file or directory
Killed
What's
ASCII character encoding means that the database does not care about the
encoding. So it is the responsibility of the programs you use, to use the
correct encoding for your application. So you need to know the used encoding
of your applications/data in your database. Then you can convert a text
I'm trying to install 8.3.1 (binaries) on Win2003 using windows
installer (msi).
I'm runnning silent install with:
ADDLOCAL=server,psql,pgadmin,psqlodbc,nls
and I'm getting error message saying, that psqlodbc is not included in
the package.
When I exclude odbc:
Would like to use variables in combination with files for common psql
queries, and am using PG 8.1.4.
For example
\set table_name pg_class
select * from pg_tables where tablename = ':table_name';
This returns no rows, even though the customer table exists. It appears
to be search for
I'm trying to install 8.3.1 (binaries) on Win2003 using windows
installer (msi).
I'm runnning silent install with:
ADDLOCAL=server,psql,pgadmin,psqlodbc,nls
and I'm getting error message saying, that psqlodbc is not included in
the package.
When I exclude odbc:
Hello,
I'm backing up my databases on Monday, Wednesday, and Fridays. I'm
writing a script to further automate this process. Is there a way
that I can test to make sure that pg_dump has actually backed up the
entire system. It seems like there should be a return code or
something
Hello,
kevin kempter wrote:
log_destination = 'syslog'
#logging_collector = off
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_duration_statement = 0
Here's my /etc/syslog.conf file:
LOCAL0.*/var/log/pgsql
I dont see any files show up in
Hello,
kevin kempter wrote:
log_destination = 'syslog'
#logging_collector = off
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
silent_mode = on
log_min_duration_statement = 0
Here's my /etc/syslog.conf file:
LOCAL0.*/var/log/pgsql
I dont see any files show up in
Hi there
I've had a serious problem at a client's site where we were called in to
check our app based on postgres that wouldn't start.
After Norton 360 was installed, the source of the problem was located at
the /data directory having two missing sub-directories
/pg_twophase
/pg_tblspc
how
13 matches
Mail list logo