Flavio, veja meu comando
-bash-4.1$ psql -U postgres -c "select pg_start_backup('replicacao', true)";
-bash: psql: comando não encontrado
-bash-4.1$ ./psql -U postgres -c "select pg_start_backup('replicacao',
true)";
Password for user postgres:
pg_start_backup
-----------------
2/62000020
(1 row)
show all
allow_system_table_mods;off
application_name;pgAdmin III - Query Tool
archive_command;(disabled)
archive_mode;off
archive_timeout;0
array_nulls;on
authentication_timeout;1min
autovacuum;on
autovacuum_analyze_scale_factor;0.1
autovacuum_analyze_threshold;50
autovacuum_freeze_max_age;200000000
autovacuum_max_workers;3
autovacuum_naptime;1min
autovacuum_vacuum_cost_delay;20ms
autovacuum_vacuum_cost_limit;-1
autovacuum_vacuum_scale_factor;0.2
autovacuum_vacuum_threshold;50
backslash_quote;safe_encoding
bgwriter_delay;200ms
bgwriter_lru_maxpages;100
bgwriter_lru_multiplier;2
block_size;8192
bonjour;off
bonjour_name;
bytea_output;escape
check_function_bodies;on
checkpoint_completion_target;0.5
checkpoint_segments;3
checkpoint_timeout;5min
checkpoint_warning;30s
client_encoding;UNICODE
client_min_messages;notice
commit_delay;0
commit_siblings;5
constraint_exclusion;partition
cpu_index_tuple_cost;0.005
cpu_operator_cost;0.0025
cpu_tuple_cost;0.01
cursor_tuple_fraction;0.1
DateStyle;ISO, DMY
db_user_namespace;off
deadlock_timeout;1s
debug_assertions;off
debug_pretty_print;on
debug_print_parse;off
debug_print_plan;off
debug_print_rewritten;off
default_statistics_target;100
default_tablespace;
default_text_search_config;pg_catalog.portuguese
default_transaction_deferrable;off
default_transaction_isolation;read committed
default_transaction_read_only;off
default_with_oids;off
effective_cache_size;128MB
effective_io_concurrency;1
enable_bitmapscan;on
enable_hashagg;on
enable_hashjoin;on
enable_indexonlyscan;on
enable_indexscan;on
enable_material;on
enable_mergejoin;on
enable_nestloop;on
enable_seqscan;on
enable_sort;on
enable_tidscan;on
escape_string_warning;on
event_source;PostgreSQL
exit_on_error;off
extra_float_digits;0
from_collapse_limit;8
fsync;on
full_page_writes;on
geqo;on
geqo_effort;5
geqo_generations;0
geqo_pool_size;0
geqo_seed;0
geqo_selection_bias;2
geqo_threshold;12
gin_fuzzy_search_limit;0
hot_standby;off
hot_standby_feedback;off
ignore_system_indexes;off
integer_datetimes;on
IntervalStyle;postgres
join_collapse_limit;8
krb_caseins_users;off
krb_srvname;postgres
lc_collate;pt_BR.UTF-8
lc_ctype;pt_BR.UTF-8
lc_messages;pt_BR.UTF-8
lc_monetary;pt_BR.UTF-8
lc_numeric;pt_BR.UTF-8
lc_time;pt_BR.UTF-8
listen_addresses;*
lo_compat_privileges;off
local_preload_libraries;
log_autovacuum_min_duration;-1
log_checkpoints;off
log_connections;off
log_destination;stderr
log_disconnections;off
log_duration;off
log_error_verbosity;default
log_executor_stats;off
log_file_mode;0600
log_hostname;off
log_line_prefix;%t
log_lock_waits;off
log_min_duration_statement;-1
log_min_error_statement;error
log_min_messages;warning
log_parser_stats;off
log_planner_stats;off
log_rotation_age;1d
log_rotation_size;10MB
log_statement;none
log_statement_stats;off
log_temp_files;-1
log_timezone;Brazil/East
log_truncate_on_rotation;off
logging_collector;on
maintenance_work_mem;16MB
max_connections;100
max_files_per_process;1000
max_function_args;100
max_identifier_length;63
max_index_keys;32
max_locks_per_transaction;64
max_pred_locks_per_transaction;64
max_prepared_transactions;0
max_stack_depth;2MB
max_standby_archive_delay;30s
max_standby_streaming_delay;30s
max_wal_senders;1
password_encryption;on
port;5432
post_auth_delay;0
pre_auth_delay;0
quote_all_identifiers;off
random_page_cost;4
replication_timeout;1min
restart_after_crash;on
search_path;$user,public
segment_size;1GB
seq_page_cost;1
server_encoding;UTF8
server_version;9.2.4
server_version_num;90204
session_replication_role;origin
shared_buffers;32MB
sql_inheritance;on
ssl;off
ssl_ca_file;
ssl_cert_file;server.crt
ssl_crl_file;
ssl_key_file;server.key
ssl_renegotiation_limit;512MB
standard_conforming_strings;on
statement_timeout;0
superuser_reserved_connections;3
synchronize_seqscans;on
synchronous_commit;on
synchronous_standby_names;
syslog_facility;local0
syslog_ident;postgres
tcp_keepalives_count;9
tcp_keepalives_idle;7200
tcp_keepalives_interval;75
temp_buffers;8MB
temp_file_limit;-1
temp_tablespaces;
TimeZone;Brazil/East
timezone_abbreviations;Default
trace_notify;off
trace_recovery_messages;log
trace_sort;off
track_activities;on
track_activity_query_size;1024
track_counts;on
track_functions;none
track_io_timing;off
transaction_deferrable;off
transaction_isolation;read committed
transaction_read_only;off
transform_null_equals;off
unix_socket_group;
unix_socket_permissions;0777
update_process_title;on
vacuum_cost_delay;0
vacuum_cost_limit;200
vacuum_cost_page_dirty;20
vacuum_cost_page_hit;1
vacuum_cost_page_miss;10
vacuum_defer_cleanup_age;0
vacuum_freeze_min_age;50000000
vacuum_freeze_table_age;150000000
wal_block_size;8192
wal_buffers;1MB
wal_keep_segments;20
wal_level;hot_standby
wal_receiver_status_interval;10s
wal_segment_size;16MB
wal_sync_method;fdatasync
wal_writer_delay;200ms
work_mem;1MB
xmlbinary;base64
xmloption;content
zero_damaged_pages;off
Em 21 de maio de 2013 17:24, Flavio Henrique Araque Gurgel <
[email protected]> escreveu:
> Boa tarde Flavio,
>> fui fazer um teste agora e coloquei em modo backup atraves do comando:
>> select pg_start_backup('replicacao', true); e consegui fazer operações
>> normais no ERP que utilizamos sem precisar parar o backup...
>>
>
> Sim, isso é esperado e, felizmente, é o que acontece com todo mundo :)
>
> Só um detalhe: não é possível que este comando tenha dado certo.
> SELECT pg_start_backup(...);
>
> Ele só vai funcionar se, e somente se:
> archive_mode = on
> wal_level = archive ou wal_level=hot_standby
>
> Provavelmente, o comando que você tentou executar deu erro.
>
>
> verifiquei o opção archive_mode e está como off, alguma outra dica??
>>
>
> Dica?
>
>
> []s
>
> ______________________________**____
> Flavio Henrique A. Gurgel
> Líder de Projetos Especiais
> Consultoria, Projetos & Treinamentos 4LINUX
> Tel1: +55-11.2125-4747 ou 2125-4748
> www.4linux.com.br
> email: [email protected]
> ______________________________
> FREE SOFTWARE SOLUTIONS
> ______________________________**_________________
> pgbr-geral mailing list
> [email protected].**org.br<[email protected]>
> https://listas.postgresql.org.**br/cgi-bin/mailman/listinfo/**pgbr-geral<https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral>
>
--
Douglas Fabiano Specht
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
