Saya ingin mendapatkan pencerahan mengenai instalasi postgresql 8.1 di Windows 8. Karena setelah mencoba berbagai cara (dari direct install, non-aktifkan UAC, runas /user:... hingga instalasi menggunakan user Administrator) hasilnya tetap bermasalah. Pada proses terakhir, muncul pesan "malformed permissions property langid" sehingga proses instalasi otomatis dibatalkan.

Mohon bantuannya dari rekan" semua untuk solusi ini.

Terima kasih,
Isnain

saya sudah pakai phppgadmin tapi engga bisa di export
ada masalah
Export error: Failed to execute pg_dump (given path in your conf/config.inc.php : /usr/bin/pg_dump). Please, fix this path in your configuration and relog.

ada solusinya yang lain?

thanks.

VR - 081298985363

niey aq ada permasalahan, q mau buat trigger AFTER INSERT....

jadi kalo aq sdh insert di table rs_karyawan maka akan terinsert di kolom "nik" dengan otomatis, tp aku pingin nomorNya d depanNya aq kasi "PSN-" jadi nanti hasilNya yg ada d kolom "nik" td adalah misal yg terinsert nilai 1maka "PSN-1".

TOLONG YA ABANG2 MASTER DB DISINI!!!

contoh syntax insert q :

insert into rs_karyawan (nama_kar, alamat_kar, telp_kar, jabatan_kar, tmptlhr_kar, tgllhr_kar, jnsklmn_kar, pend_kar, agama_kar, psnaktf, log_kar, date_kar) values('arie', 'balongsari', '7402234', 'ob', 'surabaya', '2010-12-11 00:00:00', 'L', 'sma', 'islam', 'y', 'system', current_timestamp)";

table q :

CREATE TABLE rs_karyawan 
(
    nik         VARCHAR(10) not null, 
    nama_kar     VARCHAR(30), 
    alamat_kar    VARCHAR(100), 
    telp_kar     VARCHAR(20), 
    jabatan_kar     VARCHAR(30), 
    tmptlhr_kar     VARCHAR(30), 
    tgllhr_kar     TIMESTAMP, 
    jnsklmn_kar    VARCHAR(30), 
    pend_kar     VARCHAR(30), 
    agama_kar     VARCHAR(30), 
    psnaktf     VARCHAR(1), 
    log_kar     VARCHAR(30), 
    date_kar     TIMESTAMP, 
    CONSTRAINT PK_rs_karyawan primary key(nik)
);

auto increment q buat masukin di kolom "nik" otomatis :

CREATE SEQUENCE rs_karyawan_seq;
ALTER TABLE rs_karyawan 
    ALTER COLUMN nik 
        SET DEFAULT NEXTVAL('rs_karyawan_seq');

hasil percobaan q n' hasilNya GAGAL (MOHON DIBENERIN YANG SALAH) :

CREATE OR REPLACE FUNCTION bef_ins_rs_kar_fun()
RETURNS TRIGGER AS
$BODY$ DECLARE
DECLARE
userids VARCHAR(10);
textadd VARCHAR(10);
BEGIN
userids := NEW.nik;
textadd := 'PSN-';
UPDATE rs_karyawan SET nik=textadd+userids WHERE nik=userids;
RETURN NEW;
END;
$BODY$ LANGUAGE plpgsql;
CREATE TRIGGER bef_ins_rs_kar_trg AFTER INSERT ON rs_karyawan
FOR EACH ROW EXECUTE PROCEDURE bef_ins_rs_kar_fun();

Saya sedang membangun server database menggunakan PostGreSQL 8.3 di linux CentOS, mulai dari data karyawan, keuangan, penjualan, customer, dll. Saya sedang bingung apakah sebaiknya semua itu menjadi satu nama database misalnya mydata atau banyak database sendiri2 menjadi database karyawan, keuangan, penjualan, customer, dll. Sementara saya buat sendiri2 tapi untuk beberapa keperluan mesti harus menggunakan data dari database yg berbeda.

Mohon saran nya para suhu dan siapa saja yg punya pertimbangan dalam masalah ini ..

Terima kasih..

debian:/usr/local/src/postgresql-8.3.10# ./configure
checking build system type... i686-pc-linux-gnuoldld
checking host system type... i686-pc-linux-gnuoldld
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... no
checking whether NLS is wanted... no
checking for default port number... 5432
checking for gcc... no
checking for cc... no
configure: error: no acceptable C compiler found in $PATH
See `config.log' for more details.
debian:/usr/local/src/postgresql-8.3.10#

------------------------------------------------------------------------------------
trus, sy liat config.log nya .... katanya gini:

This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.

It was created by PostgreSQL configure 8.3.10, which was
generated by GNU Autoconf 2.59.  Invocation command line was

  $ ./configure

## --------- ##
## Platform. ##
## --------- ##

hostname = debian
uname -m = i686
uname -r = 2.6.26-2-686
uname -s = Linux
uname -v = #1 SMP Sun Jun 21 04:57:38 UTC 2009

/usr/bin/uname -p = unknown
/bin/uname -X     = unknown

/bin/arch              = unknown
/usr/bin/arch -k       = unknown
/usr/convex/getsysinfo = unknown
hostinfo               = unknown
/bin/machine           = unknown
/usr/bin/oslevel       = unknown
/bin/universe          = unknown

PATH: /usr/local/sbin
PATH: /usr/local/bin
PATH: /usr/sbin
PATH: /usr/bin
PATH: /sbin
PATH: /bin

## ----------- ##
## Core tests. ##
## ----------- ##

configure:1414: checking build system type
configure:1432: result: i686-pc-linux-gnuoldld
configure:1440: checking host system type
configure:1454: result: i686-pc-linux-gnuoldld
configure:1464: checking which template to use
configure:1564: result: linux
configure:1706: checking whether to build with 64-bit integer date/time support
configure:1738: result: no
configure:1745: checking whether NLS is wanted
configure:1780: result: no
configure:1788: checking for default port number
configure:1818: result: 5432
configure:2160: checking for gcc
configure:2189: result: no
configure:2160: checking for cc
configure:2189: result: no
configure:2201: error: no acceptable C compiler found in $PATH
See `config.log' for more details.

## ---------------- ##
## Cache variables. ##
## ---------------- ##

ac_cv_build=i686-pc-linux-gnuoldld
ac_cv_build_alias=i686-pc-linux-gnuoldld
ac_cv_env_CC_set=
ac_cv_env_CC_value=
ac_cv_env_CFLAGS_set=
ac_cv_env_CFLAGS_value=
ac_cv_env_CPPFLAGS_set=
ac_cv_env_CPPFLAGS_value=
ac_cv_env_CPP_set=
ac_cv_env_CPP_value=
ac_cv_env_DOCBOOKSTYLE_set=
ac_cv_env_DOCBOOKSTYLE_value=
ac_cv_env_LDFLAGS_SL_set=
ac_cv_env_LDFLAGS_SL_value=
ac_cv_env_LDFLAGS_set=
ac_cv_env_LDFLAGS_value=
ac_cv_env_build_alias_set=
ac_cv_env_build_alias_value=
ac_cv_env_host_alias_set=
ac_cv_env_host_alias_value=
ac_cv_env_target_alias_set=
ac_cv_env_target_alias_value=
ac_cv_host=i686-pc-linux-gnuoldld
ac_cv_host_alias=i686-pc-linux-gnuoldld

## ----------------- ##
## Output variables. ##
## ----------------- ##

AWK=''
CC=''
CFLAGS=''
COLLATEINDEX=''
CPP=''
CPPFLAGS=''
DEFS=''
DOCBOOKSTYLE=''
DTRACE=''
DTRACEFLAGS=''
ECHO_C=''
ECHO_N='-n'
ECHO_T=''
EGREP=''
ELF_SYS=''
EXEEXT=''
FLEX=''
FLEXFLAGS=''
GCC=''
HAVE_IPV6=''
HAVE_POSIX_SIGNALS=''
INCLUDES=''
JADE=''
LD=''
LDAP_LIBS_BE=''
LDAP_LIBS_FE=''
LDFLAGS=''
LDFLAGS_SL=''
LIBOBJS=''
LIBS=''
LN_S=''
LTLIBOBJS=''
MSGFMT=''
MSGMERGE=''
NSGMLS=''
OBJEXT=''
OSSP_UUID_LIBS=''
PACKAGE_BUGREPORT='[email protected]'
PACKAGE_NAME='PostgreSQL'
PACKAGE_STRING='PostgreSQL 8.3.10'
PACKAGE_TARNAME='postgresql'
PACKAGE_VERSION='8.3.10'
PATH_SEPARATOR=':'
PERL=''
PORTNAME='linux'
PTHREAD_CC=''
PTHREAD_CFLAGS=''
PTHREAD_LIBS=''
PYTHON=''
RANLIB=''
SGMLSPL=''
SHELL='/bin/sh'
STRIP=''
STRIP_SHARED_LIB=''
STRIP_STATIC_LIB=''
TAR=''
TAS=''
TCLSH=''
TCL_CONFIG_SH=''
TCL_INCLUDE_SPEC=''
TCL_LIBS=''
TCL_LIB_FILE=''
TCL_LIB_SPEC=''
TCL_SHARED_BUILD=''
TCL_SHLIB_LD_LIBS=''
WANTED_LANGUAGES=''
XGETTEXT=''
XML2_CONFIG=''
YACC=''
YFLAGS=''
ac_ct_CC=''
ac_ct_RANLIB=''
ac_ct_STRIP=''
acx_pthread_config=''
autodepend=''
bindir='${exec_prefix}/bin'
build='i686-pc-linux-gnuoldld'
build_alias=''
build_cpu='i686'
build_os='linux-gnuoldld'
build_vendor='pc'
configure_args=''
datadir='${prefix}/share'
default_port='5432'
docdir='${prefix}/doc'
enable_debug='no'
enable_dtrace='no'
enable_nls='no'
enable_profiling='no'
enable_rpath='yes'
enable_shared='yes'
enable_thread_safety=''
exec_prefix='NONE'
have_docbook=''
host='i686-pc-linux-gnuoldld'
host_alias=''
host_cpu='i686'
host_os='linux-gnuoldld'
host_vendor='pc'
includedir='${prefix}/include'
infodir='${prefix}/info'
krb_srvtab=''
ld_R_works=''
libdir='${exec_prefix}/lib'
libexecdir='${exec_prefix}/libexec'
localedir=''
localstatedir='${prefix}/var'
mandir='${prefix}/man'
oldincludedir='/usr/include'
perl_archlibexp=''
perl_embed_ldflags=''
perl_privlibexp=''
perl_useshrplib=''
prefix='NONE'
program_transform_name='s,x,x,'
python_additional_libs=''
python_configdir=''
python_includespec=''
python_libdir=''
python_libspec=''
python_version=''
sbindir='${exec_prefix}/sbin'
sharedstatedir='${prefix}/com'
sysconfdir='${prefix}/etc'
target_alias=''
vpath_build=''
with_bonjour=''
with_gnu_ld=''
with_gssapi=''
with_krb5=''
with_ldap=''
with_libxml=''
with_libxslt=''
with_openssl=''
with_ossp_uuid=''
with_pam=''
with_perl=''
with_python=''
with_system_tzdata=''
with_tcl=''
with_zlib=''

## ----------- ##
## confdefs.h. ##
## ----------- ##

#define DEF_PGPORT 5432
#define DEF_PGPORT_STR "5432"
#define PACKAGE_BUGREPORT "[email protected]"
#define PACKAGE_NAME "PostgreSQL"
#define PACKAGE_STRING "PostgreSQL 8.3.10"
#define PACKAGE_TARNAME "postgresql"
#define PACKAGE_VERSION "8.3.10"
#define PG_VERSION "8.3.10"

configure: exit 1

--------------------------- msalahnya dimana ya?
apa ini no acceptable C compiler found in $PATH...
gimana solusi dan installasinya (sy di debian GNU/Linux 5.0.2 Lenny)?
Mohon pencerahannya..
Terima kasih buat Bpk2 / Ibu2 sekalian